DBA Data[Home] [Help]

APPS.PA_BILL_REV_XLA_UPGRADE dependencies on PA_CUST_REV_DIST_LINES_ALL

Line 716: FROM PA_CUST_REV_DIST_LINES_ALL CRDL,

712: 'Revenue - Normal Revenue' gl_category,
713: rownum row_num,
714: dr.accounting_date accounting_date,
715: dr.ledger_id ledger_id
716: FROM PA_CUST_REV_DIST_LINES_ALL CRDL,
717: PA_XLA_DRAFT_REV_TMP DR
718: WHERE DR.DRAFT_REVENUE_NUM = CRDL.DRAFT_REVENUE_NUM
719: AND DR.PROJECT_ID = CRDL.PROJECT_ID
720: /*AND NVL(CRDL.AMOUNT, 0) <> 0 Commented for Bug 10302541 */

Line 1431: FROM PA_CUST_REV_DIST_LINES_ALL CRDL,

1427: 'Revenue - Normal Revenue' gl_category,
1428: rownum row_num,
1429: mc.accounting_date accounting_date,
1430: mc.REP_SET_OF_BOOKS_ID ledger_id
1431: FROM PA_CUST_REV_DIST_LINES_ALL CRDL,
1432: PA_MC_CUST_RDL_ALL mcrdl,
1433: PA_XLA_DRAFT_REV_TMP MC
1434: WHERE mc.project_id = mcrdl.project_id
1435: AND mc.draft_revenue_num = mcrdl.draft_revenue_num