VIEW: APPS.PA_RETN_INVOICE_DETAILS_V

Source

View Text - Preformatted

SELECT DII.PROJECT_ID, DII.DRAFT_INVOICE_NUM, DII.LINE_NUM , RID.PROJECT_RETENTION_ID, PPR.RETENTION_RULE_ID, PPRR.TOTAL_RETAINED, PPR.PROJECT_TOTAL_RETAINED, PPR.FUNDING_TOTAL_RETAINED, T.TASK_NUMBER||' '||T.TASK_NAME, PPRR.EXPENDITURE_CATEGORY, PPRR.EXPENDITURE_TYPE, PPRR.REVENUE_CATEGORY_CODE, LK.MEANING, PPRR.EVENT_TYPE, PPRR.NON_LABOR_RESOURCE, PPRR.EFFECTIVE_START_DATE, PPRR.EFFECTIVE_END_DATE, PPRR.RETENTION_PERCENTAGE, PPRR.RETENTION_AMOUNT, PPRR.PROJFUNC_TOTAL_RETAINED FROM PA_DRAFT_INVOICES_ALL DI, PA_DRAFT_INVOICE_ITEMS DII, PA_RETN_INVOICE_DETAILS RID, PA_PROJECT_RETENTIONS PPR, PA_PROJ_RETN_RULES PPRR , PA_TASKS T, PA_LOOKUPS LK WHERE DII.PROJECT_ID=RID.PROJECT_ID AND DII.DRAFT_INVOICE_NUM=RID.DRAFT_INVOICE_NUM AND DII.LINE_NUM=RID.LINE_NUM AND DI.PROJECT_ID=DII.PROJECT_ID AND DI.DRAFT_INVOICE_NUM=DII.DRAFT_INVOICE_NUM AND PPR.PROJECT_RETENTION_ID=RID.PROJECT_RETENTION_ID AND PPR.RETENTION_RULE_ID=PPRR.RETENTION_RULE_ID AND PPRR.TASK_ID=T.TASK_ID(+) AND DI.RETENTION_INVOICE_FLAG = 'Y' AND DII.INVOICE_LINE_TYPE='RETENTION' AND LK.LOOKUP_TYPE(+) = 'REVENUE CATEGORY' AND LK.LOOKUP_CODE(+) = PPRR.REVENUE_CATEGORY_CODE

View Text - HTML Formatted

SELECT DII.PROJECT_ID
, DII.DRAFT_INVOICE_NUM
, DII.LINE_NUM
, RID.PROJECT_RETENTION_ID
, PPR.RETENTION_RULE_ID
, PPRR.TOTAL_RETAINED
, PPR.PROJECT_TOTAL_RETAINED
, PPR.FUNDING_TOTAL_RETAINED
, T.TASK_NUMBER||' '||T.TASK_NAME
, PPRR.EXPENDITURE_CATEGORY
, PPRR.EXPENDITURE_TYPE
, PPRR.REVENUE_CATEGORY_CODE
, LK.MEANING
, PPRR.EVENT_TYPE
, PPRR.NON_LABOR_RESOURCE
, PPRR.EFFECTIVE_START_DATE
, PPRR.EFFECTIVE_END_DATE
, PPRR.RETENTION_PERCENTAGE
, PPRR.RETENTION_AMOUNT
, PPRR.PROJFUNC_TOTAL_RETAINED
FROM PA_DRAFT_INVOICES_ALL DI
, PA_DRAFT_INVOICE_ITEMS DII
, PA_RETN_INVOICE_DETAILS RID
, PA_PROJECT_RETENTIONS PPR
, PA_PROJ_RETN_RULES PPRR
, PA_TASKS T
, PA_LOOKUPS LK
WHERE DII.PROJECT_ID=RID.PROJECT_ID
AND DII.DRAFT_INVOICE_NUM=RID.DRAFT_INVOICE_NUM
AND DII.LINE_NUM=RID.LINE_NUM
AND DI.PROJECT_ID=DII.PROJECT_ID
AND DI.DRAFT_INVOICE_NUM=DII.DRAFT_INVOICE_NUM
AND PPR.PROJECT_RETENTION_ID=RID.PROJECT_RETENTION_ID
AND PPR.RETENTION_RULE_ID=PPRR.RETENTION_RULE_ID
AND PPRR.TASK_ID=T.TASK_ID(+)
AND DI.RETENTION_INVOICE_FLAG = 'Y'
AND DII.INVOICE_LINE_TYPE='RETENTION'
AND LK.LOOKUP_TYPE(+) = 'REVENUE CATEGORY'
AND LK.LOOKUP_CODE(+) = PPRR.REVENUE_CATEGORY_CODE