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
1477: 'Revenue - Event Revenue' gl_category,
1478: rownum row_num,
1479: mc.accounting_date accounting_date,
1480: mc.REP_SET_OF_BOOKS_ID ledger_id
1481: FROM PA_CUST_EVENT_RDL_ALL erdl,
1482: PA_MC_CUST_EVENT_RDL_ALL mcerdl,
1483: PA_EVENTS ev,
1484: PA_XLA_DRAFT_REV_TMP MC,
1485: PA_EVENT_TYPES et