11i: Standard Report GLXACSDW.rdf Query --Need to understand the functionality
The 11i standard report - GLXACSDW.rdf uses below query in the Program Unit -- GL_GET_DRLDN_DATA.
In our data base, we could not find any data where the codtions AE.source_table = 'AP_CHECKS' AND AEL.source_table = 'AP_INVOICE_DISTRIBUTIONS' is satisfied.
At any point of time, can AP_CHECKS be related to AP_INVOICE_DISTRIBTUTIONS ??
.We are trying to understand the logical /functional relation between the two.
---
where
L1.lookup_code = AEL.ae_line_type_code AND
L1.lookup_type = 'AE LINE TYPE' AND
AE.source_table = 'AP_CHECKS' AND
AE.accounting_event_id = AEH.accounting_event_id AND