VIEW: APPS.PABV_REVENUE_DISTRIBUTIONS

Source

View Text - Preformatted

SELECT prdl.expenditure_item_id , prdl.line_num , pdr.released_date , prdl.amount , '_LA:additional_revenue_flag:FND_LOOKUPS:YES_NO:MEANING' , prdl.function_code , pdr.pa_date , pdr.gl_date , '_LA:transfer_status_code:PA_LOOKUPS:TRANSFER STATUS:MEANING' , pdr.transferred_date , pdr.transfer_rejection_reason , pdr.agreement_id , prdl.project_id , to_number(NULL) /* Task ID */ , to_number(NULL) /* Event Number*/ , prdl.org_id /* operating unit */ , prdl.CREATION_DATE , prdl.CREATED_BY FROM pa_cust_rev_dist_lines_all prdl , pa_draft_revenues_all pdr WHERE pdr.project_id = prdl.project_id AND pdr.draft_revenue_num = prdl.draft_revenue_num and '_SEC:prdl.org_id' is not null UNION SELECT to_number(NULL) /* Expenditure Item ID */ , perdl.line_num , pdr.released_date , perdl.amount , '_LA:to_char(NULL):FND_LOOKUPS:YES_NO:MEANING' , to_char(NULL) /* function code */ , pdr.pa_date , pdr.gl_date , '_LA:transfer_status_code:PA_LOOKUPS:TRANSFERSTATUS:MEANING' , pdr.transferred_date , pdr.transfer_rejection_reason , pdr.agreement_id , perdl.project_id , perdl.task_id , perdl.event_num , perdl.org_id /* operating unit */ , perdl.CREATION_DATE , perdl.CREATED_BY FROM pa_cust_event_rdl_all perdl , pa_draft_revenues_all pdr WHERE pdr.project_id = perdl.project_id AND pdr.draft_revenue_num = perdl.draft_revenue_num and '_SEC:perdl.org_id' is not null WITH READ ONLY

View Text - HTML Formatted

SELECT PRDL.EXPENDITURE_ITEM_ID
, PRDL.LINE_NUM
, PDR.RELEASED_DATE
, PRDL.AMOUNT
, '_LA:ADDITIONAL_REVENUE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PRDL.FUNCTION_CODE
, PDR.PA_DATE
, PDR.GL_DATE
, '_LA:TRANSFER_STATUS_CODE:PA_LOOKUPS:TRANSFER STATUS:MEANING'
, PDR.TRANSFERRED_DATE
, PDR.TRANSFER_REJECTION_REASON
, PDR.AGREEMENT_ID
, PRDL.PROJECT_ID
, TO_NUMBER(NULL) /* TASK ID */
, TO_NUMBER(NULL) /* EVENT NUMBER*/
, PRDL.ORG_ID /* OPERATING UNIT */
, PRDL.CREATION_DATE
, PRDL.CREATED_BY
FROM PA_CUST_REV_DIST_LINES_ALL PRDL
, PA_DRAFT_REVENUES_ALL PDR
WHERE PDR.PROJECT_ID = PRDL.PROJECT_ID
AND PDR.DRAFT_REVENUE_NUM = PRDL.DRAFT_REVENUE_NUM
AND '_SEC:PRDL.ORG_ID' IS NOT NULL UNION SELECT TO_NUMBER(NULL) /* EXPENDITURE ITEM ID */
, PERDL.LINE_NUM
, PDR.RELEASED_DATE
, PERDL.AMOUNT
, '_LA:TO_CHAR(NULL):FND_LOOKUPS:YES_NO:MEANING'
, TO_CHAR(NULL) /* FUNCTION CODE */
, PDR.PA_DATE
, PDR.GL_DATE
, '_LA:TRANSFER_STATUS_CODE:PA_LOOKUPS:TRANSFERSTATUS:MEANING'
, PDR.TRANSFERRED_DATE
, PDR.TRANSFER_REJECTION_REASON
, PDR.AGREEMENT_ID
, PERDL.PROJECT_ID
, PERDL.TASK_ID
, PERDL.EVENT_NUM
, PERDL.ORG_ID /* OPERATING UNIT */
, PERDL.CREATION_DATE
, PERDL.CREATED_BY
FROM PA_CUST_EVENT_RDL_ALL PERDL
, PA_DRAFT_REVENUES_ALL PDR
WHERE PDR.PROJECT_ID = PERDL.PROJECT_ID
AND PDR.DRAFT_REVENUE_NUM = PERDL.DRAFT_REVENUE_NUM
AND '_SEC:PERDL.ORG_ID' IS NOT NULL WITH READ ONLY