View: PA_RETN_INVOICE_DETAILS_V

Product:	PA - Projects
Description:	11i Retention View
Implementation/DBA Data:	APPS.PA_RETN_INVOICE_DETAILS_V

View Text

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

Columns