eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PAFV_REVENUE_DISTRIBUTIONS

Source

View Text - Preformatted


SELECT prdl.expenditure_item_id , prdl.line_num , pdr.released_date , prdl.amount , prdl.function_code , pdr.pa_date , pdr.gl_date , pdr.transferred_date , pdr.transfer_rejection_reason , pdr.agreement_id , prdl.project_id , to_number(NULL) , to_number(NULL) , to_char(null) , prdl.org_id , prdl.CREATION_DATE , prdl.CREATED_BY , '_LA:additional_revenue_flag:FND_LOOKUPS:YES_NO:MEANING' , '_LA:transfer_status_code:PA_LOOKUPS:TRANSFER STATUS:MEANING' 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 ALL SELECT to_number(NULL) , perdl.line_num , pdr.released_date , perdl.amount , to_char(NULL) , pdr.pa_date , pdr.gl_date , pdr.transferred_date , pdr.transfer_rejection_reason , pdr.agreement_id , perdl.project_id , perdl.task_id , perdl.event_num , pe.description , perdl.org_id , perdl.CREATION_DATE , perdl.CREATED_BY , '_LA:to_char(NULL):FND_LOOKUPS:YES_NO:MEANING' , '_LA:transfer_status_code:PA_LOOKUPS:TRANSFERSTATUS:MEANING' FROM pa_cust_event_rdl_all perdl , pa_draft_revenues_all pdr , pa_events pe WHERE pdr.project_id = perdl.project_id and pdr.draft_revenue_num = perdl.draft_revenue_num and nvl(perdl.task_id,-1) = nvl(pe.task_id,-1) and perdl.event_num = pe.event_num and perdl.project_id = pe.project_id 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
, PRDL.FUNCTION_CODE
, PDR.PA_DATE
, PDR.GL_DATE
, PDR.TRANSFERRED_DATE
, PDR.TRANSFER_REJECTION_REASON
, PDR.AGREEMENT_ID
, PRDL.PROJECT_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, PRDL.ORG_ID
, PRDL.CREATION_DATE
, PRDL.CREATED_BY
, '_LA:ADDITIONAL_REVENUE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:TRANSFER_STATUS_CODE:PA_LOOKUPS:TRANSFER STATUS:MEANING'
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 ALL SELECT TO_NUMBER(NULL)
, PERDL.LINE_NUM
, PDR.RELEASED_DATE
, PERDL.AMOUNT
, TO_CHAR(NULL)
, PDR.PA_DATE
, PDR.GL_DATE
, PDR.TRANSFERRED_DATE
, PDR.TRANSFER_REJECTION_REASON
, PDR.AGREEMENT_ID
, PERDL.PROJECT_ID
, PERDL.TASK_ID
, PERDL.EVENT_NUM
, PE.DESCRIPTION
, PERDL.ORG_ID
, PERDL.CREATION_DATE
, PERDL.CREATED_BY
, '_LA:TO_CHAR(NULL):FND_LOOKUPS:YES_NO:MEANING'
, '_LA:TRANSFER_STATUS_CODE:PA_LOOKUPS:TRANSFERSTATUS:MEANING'
FROM PA_CUST_EVENT_RDL_ALL PERDL
, PA_DRAFT_REVENUES_ALL PDR
, PA_EVENTS PE
WHERE PDR.PROJECT_ID = PERDL.PROJECT_ID
AND PDR.DRAFT_REVENUE_NUM = PERDL.DRAFT_REVENUE_NUM
AND NVL(PERDL.TASK_ID
, -1) = NVL(PE.TASK_ID
, -1)
AND PERDL.EVENT_NUM = PE.EVENT_NUM
AND PERDL.PROJECT_ID = PE.PROJECT_ID
AND '_SEC:PERDL.ORG_ID' IS NOT NULL WITH READ ONLY