SELECT PCER.LINE_NUM , PCER.EVENT_NUM , PCER.TASK_ID , PCER.DRAFT_REVENUE_NUM , PCER.AMOUNT , TO_NUMBER(NULL) , PCER.CREATION_DATE , PCER.CREATED_BY FROM PA_CUST_EVENT_RDL_ALL PCER , PA_DRAFT_INVOICE_ITEMS PDII WHERE PCER.PROJECT_ID = PDII.PROJECT_ID(+) AND PCER.DRAFT_INVOICE_NUM = PDII.DRAFT_INVOICE_NUM(+) AND PCER.DRAFT_INVOICE_ITEM_LINE_NUM = PDII.LINE_NUM(+) AND PCER.DRAFT_INVOICE_NUM IS NOT NULL AND PCER.DRAFT_INVOICE_ITEM_LINE_NUM IS NOT NULL AND '_SEC:PCER.ORG_ID' IS NOT NULL UNION SELECT PCRD.LINE_NUM , TO_NUMBER(NULL) , TO_NUMBER(NULL) , PCRD.DRAFT_REVENUE_NUM , PCRD.AMOUNT , PCRD.EXPENDITURE_ITEM_ID , PCRD.CREATION_DATE , PCRD.CREATED_BY FROM PA_CUST_REV_DIST_LINES_ALL PCRD , PA_DRAFT_INVOICE_ITEMS PDII WHERE PCRD.PROJECT_ID = PDII.PROJECT_ID(+) AND PCRD.DRAFT_INVOICE_NUM = PDII.DRAFT_INVOICE_NUM(+) AND PCRD.DRAFT_INVOICE_ITEM_LINE_NUM = PDII.LINE_NUM(+) AND PCRD.DRAFT_INVOICE_NUM IS NOT NULL AND PCRD.DRAFT_INVOICE_ITEM_LINE_NUM IS NOT NULL AND '_SEC:PCRD.ORG_ID' IS NOT NULL WITH READ ONLY