11i : Stanadard GLXACSDW.rdf Query ---No data in 11i when ap_accounting_events_all.SOURCE_TABLE =
Below is a standard query from 11i which pulls data from AP_ACCOUNTING_EVENTS_ALL when source table co9lumn =AP_PAYMENT_HISTORY.
In our system we are not able to find even a single record IN AP_ACCOUNTING_EVENTS_ALL when source table column =AP_PAYMENT_HISTORY.
Can some one please explain the functionality of below standard query and if it possible to have data pulled from below query ??
select
L1.displayed_field ACCT_LINE_TYPE_NAME,
to_number(null) TRX_LINE_NUMBER,
AEL.currency_code CURRENCY_CODE,
to_char(C.CHECK_NUMBER) TRX_NUMBER_DISPLAYED ,
AEL.entered_dr ENTERED_DR,