Payables and Cash Management - EBS (MOSC)

MOSC Banner

11i: Standard Report GLXACSDW.rdf Query --Need to understand the functionality

edited Dec 28, 2012 8:50AM in Payables and Cash Management - EBS (MOSC) 3 commentsAnswered
Hi there,

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

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