VIEW: APPS.PABV_INVOICE_LINE_DETAILS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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