750: 'Revenue - Event Revenue' gl_category,
751: rownum row_num,
752: dr.accounting_date accounting_date,
753: dr.ledger_id ledger_id
754: FROM PA_CUST_EVENT_RDL_ALL ERDL,
755: PA_XLA_DRAFT_REV_TMP DR,
756: PA_EVENTS ev,
757: PA_EVENT_TYPES et
758: WHERE DR.DRAFT_REVENUE_NUM = ERDL.DRAFT_REVENUE_NUM
1478: 'Revenue - Event Revenue' gl_category,
1479: rownum row_num,
1480: mc.accounting_date accounting_date,
1481: mc.REP_SET_OF_BOOKS_ID ledger_id
1482: FROM PA_CUST_EVENT_RDL_ALL erdl,
1483: PA_MC_CUST_EVENT_RDL_ALL mcerdl,
1484: PA_EVENTS ev,
1485: PA_XLA_DRAFT_REV_TMP MC,
1486: PA_EVENT_TYPES et