VIEW: APPS.PA_ADW_R_BGT_LINES_B_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)