Forum Stats

  • 3,875,317 Users
  • 2,266,908 Discussions
  • 7,912,152 Comments

Discussions

Query to Link Oracle Fusion Applications Cloud - Link PJC_EXP_ITEMS_ALL witch SubLedgerAccount (SLA)

vhmontenegro
vhmontenegro Member Posts: 1 Green Ribbon
edited Sep 26, 2022 3:14PM in Oracle Analytics Cloud

Dear All,

About Oracle Fusion Applications Cloud (Oracle's SaaS ERP) .

How can I Link what exists in the Project Costing Table (PJC_EXP_ITEMS_ALL) with what is Accounted for, through the SubLedgerAccounting (SLA), for a Receipt Accounting origin?

Greetings and thanks in advance.

Tagged:

Answers

  • TooManyBugs
    TooManyBugs Member Posts: 1 Red Ribbon

    You can use below table to link to Sub-Ledger.

    PJC_COST_DIST_LINES_ALL e

    XLA_DISTRIBUTION_LINKS xdl


     and xdl.SOURCE_DISTRIBUTION_ID_NUM_1 (+) = e.EXPENDITURE_ITEM_ID

     and xdl.SOURCE_DISTRIBUTION_ID_NUM_2 (+) = e.LINE_NUM