VIEW: APPS.PA_ADW_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 , DECODE(PBEM.TIME_PHASED_TYPE_CODE,'P',PBL.RAW_COST, PA_MISC.SPREAD_AMOUNT('L',PBL.START_DATE, PBL.END_DATE, PP.START_DATE,PP.END_DATE, PBL.RAW_COST)) , DECODE(PBEM.TIME_PHASED_TYPE_CODE,'P',PBL.BURDENED_COST, PA_MISC.SPREAD_AMOUNT('L',PBL.START_DATE, PBL.END_DATE, PP.START_DATE,PP.END_DATE, PBL.BURDENED_COST)) , DECODE(PBEM.TIME_PHASED_TYPE_CODE,'P',PBL.REVENUE, PA_MISC.SPREAD_AMOUNT('L',PBL.START_DATE, PBL.END_DATE, PP.START_DATE,PP.END_DATE, PBL.REVENUE)) , DECODE(PBEM.TIME_PHASED_TYPE_CODE,'P',PBL.QUANTITY, PA_MISC.SPREAD_AMOUNT('L',PBL.START_DATE, PBL.END_DATE, PP.START_DATE,PP.END_DATE, PBL.QUANTITY)) , TO_NUMBER(DECODE(PRA.TRACK_AS_LABOR_FLAG,'N',NULL, DECODE(PBEM.TIME_PHASED_TYPE_CODE,'P',PBL.QUANTITY, PA_MISC.SPREAD_AMOUNT('L',PBL.START_DATE, PBL.END_DATE, PP.START_DATE,PP.END_DATE, PBL.QUANTITY)))) , 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_PROJECT_TYPES PPT, PA_TASKS PT, PA_TASKS PTT, 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 PBL.RESOURCE_ASSIGNMENT_ID = PRA.RESOURCE_ASSIGNMENT_ID AND PLU.LOOKUP_TYPE = 'ADW RESOURCE NAME' AND PLU.LOOKUP_CODE = 'UNKNOWN' AND PRA.BUDGET_VERSION_ID = PBV.BUDGET_VERSION_ID AND PBV.BUDGET_ENTRY_METHOD_CODE = PBEM.BUDGET_ENTRY_METHOD_CODE AND PBV.CURRENT_FLAG = 'Y' 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
, DECODE(PBEM.TIME_PHASED_TYPE_CODE
, 'P'
, PBL.RAW_COST
, PA_MISC.SPREAD_AMOUNT('L'
, PBL.START_DATE
, PBL.END_DATE
, PP.START_DATE
, PP.END_DATE
, PBL.RAW_COST))
, DECODE(PBEM.TIME_PHASED_TYPE_CODE
, 'P'
, PBL.BURDENED_COST
, PA_MISC.SPREAD_AMOUNT('L'
, PBL.START_DATE
, PBL.END_DATE
, PP.START_DATE
, PP.END_DATE
, PBL.BURDENED_COST))
, DECODE(PBEM.TIME_PHASED_TYPE_CODE
, 'P'
, PBL.REVENUE
, PA_MISC.SPREAD_AMOUNT('L'
, PBL.START_DATE
, PBL.END_DATE
, PP.START_DATE
, PP.END_DATE
, PBL.REVENUE))
, DECODE(PBEM.TIME_PHASED_TYPE_CODE
, 'P'
, PBL.QUANTITY
, PA_MISC.SPREAD_AMOUNT('L'
, PBL.START_DATE
, PBL.END_DATE
, PP.START_DATE
, PP.END_DATE
, PBL.QUANTITY))
, TO_NUMBER(DECODE(PRA.TRACK_AS_LABOR_FLAG
, 'N'
, NULL
, DECODE(PBEM.TIME_PHASED_TYPE_CODE
, 'P'
, PBL.QUANTITY
, PA_MISC.SPREAD_AMOUNT('L'
, PBL.START_DATE
, PBL.END_DATE
, PP.START_DATE
, PP.END_DATE
, PBL.QUANTITY))))
, 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_PROJECT_TYPES PPT
, PA_TASKS PT
, PA_TASKS PTT
, 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 PBL.RESOURCE_ASSIGNMENT_ID = PRA.RESOURCE_ASSIGNMENT_ID
AND PLU.LOOKUP_TYPE = 'ADW RESOURCE NAME'
AND PLU.LOOKUP_CODE = 'UNKNOWN'
AND PRA.BUDGET_VERSION_ID = PBV.BUDGET_VERSION_ID
AND PBV.BUDGET_ENTRY_METHOD_CODE = PBEM.BUDGET_ENTRY_METHOD_CODE
AND PBV.CURRENT_FLAG = 'Y'
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(+)