View: PA_ADW_R_BGT_LINES_B_V

Product:	PA - Projects
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PA_ADW_R_BGT_LINES_B_V

View Text

SELECT PBV.PROJECT_ID
, PT.TOP_TASK_ID
, PT.TASK_ID
, PP.PERIOD_NAME || '-'|| PI.SET_OF_BOOKS_ID PA_PERIOD_KEY
, PBV.BUDGET_TYPE_CODE
, PRA.RESOURCE_LIST_MEMBER_ID
, NVL(PTT.SERVICE_TYPE_CODE
, PPT.SERVICE_TYPE_CODE)
, NVL(PT.CARRYING_OUT_ORGANIZATION_ID
, PPRJ.CARRYING_OUT_ORGANIZATION_ID)
, NVL(NVL(PRTAC.EXPENDITURE_TYPE
, PRTAP.EXPENDITURE_TYPE)
, PLU.MEANING)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, PRA.UNIT_OF_MEASURE
, PBV.ADW_NOTIFY_FLAG
FROM PA_RESOURCE_LIST_MEMBERS PRLMC
, PA_RESOURCE_LIST_MEMBERS PRLMP
, PA_RESOURCE_TXN_ATTRIBUTES PRTAC
, PA_RESOURCE_TXN_ATTRIBUTES PRTAP
, PA_IMPLEMENTATIONS PI
, GL_SETS_OF_BOOKS GSOB
, GL_PERIODS GP
, PA_PERIODS PP
, PA_BUDGET_LINES PBL
, PA_RESOURCE_ASSIGNMENTS PRA
, PA_BUDGET_VERSIONS PBV
, PA_BUDGET_ENTRY_METHODS PBEM
, PA_ADW_BGT_TYPES_B_V PBT
, PA_TASKS PT
, PA_TASKS PTT
, PA_PROJECT_TYPES PPT
, PA_ADW_RES_LISTS_B_V PRL
, PA_ADW_PROJECTS_B_V PPRJ
, PA_LOOKUPS PLU
WHERE PRLMC.RESOURCE_LIST_MEMBER_ID = PRA.RESOURCE_LIST_MEMBER_ID
AND PRLMC.RESOURCE_ID = PRTAC.RESOURCE_ID(+)
AND PRLMC.PARENT_MEMBER_ID = PRLMP.RESOURCE_LIST_MEMBER_ID(+)
AND PRLMP.RESOURCE_ID = PRTAP.RESOURCE_ID(+)
AND PRLMC.RESOURCE_LIST_ID = PRL.RESOURCE_LIST_ID
AND PLU.LOOKUP_TYPE = 'ADW RESOURCE NAME'
AND PLU.LOOKUP_CODE = 'UNKNOWN'
AND PBL.RESOURCE_ASSIGNMENT_ID = PRA.RESOURCE_ASSIGNMENT_ID
AND PRA.BUDGET_VERSION_ID = PBV.BUDGET_VERSION_ID
AND PBV.BUDGET_ENTRY_METHOD_CODE = PBEM.BUDGET_ENTRY_METHOD_CODE
AND (( PP.START_DATE <= PBL.END_DATE)
AND (PP.END_DATE >= PBL.START_DATE))
AND PP.GL_PERIOD_NAME = GP.PERIOD_NAME
AND GP.PERIOD_SET_NAME||'' = GSOB.PERIOD_SET_NAME
AND PI.SET_OF_BOOKS_ID = GSOB.SET_OF_BOOKS_ID
AND GP.ADJUSTMENT_PERIOD_FLAG = 'N'
AND PBV.BUDGET_TYPE_CODE = PBT.BUDGET_TYPE_CODE
AND PBV.PROJECT_ID = PPRJ.PROJECT_ID
AND PPRJ.PROJECT_TYPE = PPT.PROJECT_TYPE
AND PT.TOP_TASK_ID = PTT.TASK_ID(+)
AND PRA.TASK_ID = PT.TASK_ID(+)

Columns