Payables and Cash Management - EBS (MOSC)

MOSC Banner

11i : Stanadard GLXACSDW.rdf Query ---No data in 11i when ap_accounting_events_all.SOURCE_TABLE =

edited Dec 27, 2012 11:43AM in Payables and Cash Management - EBS (MOSC) 1 commentAnswered
Hi there,

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center