VIEW: APPS.PA_ONLINE_TASKS_V

Source

View Text - Preformatted

SELECT T.PROJECT_ID , P.SEGMENT1 PROJECT_NUMBER , T.TASK_ID , T.TASK_NUMBER , T.TASK_NAME , T.START_DATE , T.COMPLETION_DATE , T.CHARGEABLE_FLAG , T.billable_flag , IMP.ORG_ID , T.TASK_NUMBER || '-' || T.TASK_NAME TASK_DETAILS , NULL , NULL , NULL , T.TASK_ID , T.TOP_TASK_ID , T.TASK_MANAGER_PERSON_ID FROM PA_TASKS T, PA_PROJECTS_ALL P, PA_IMPLEMENTATIONS IMP, PA_LOOKUPS LU WHERE LU.LOOKUP_TYPE = 'PA_TASKS_TO_DISPLAY' AND LU.LOOKUP_CODE = NVL(FND_PROFILE.VALUE('PA_TASKS_DISPLAYED'),'ALL') AND (( LU.LOOKUP_CODE = 'CHARGEABLE' AND T.CHARGEABLE_FLAG = 'Y') OR ( LU.LOOKUP_CODE = 'ALL') OR (LU.LOOKUP_CODE = 'LOWEST' AND PA_TASK_UTILS.CHECK_CHILD_EXISTS(T.TASK_ID) = 0) ) AND (P.project_id = t.project_id AND( imp.org_id = p.org_id OR T.allow_cross_charge_flag = 'Y') AND NVL(P.CBS_ENABLE_FLAG, 'N') = 'N') UNION SELECT T.PROJECT_ID , P.SEGMENT1 PROJECT_NUMBER , AT.ALT_TASK_ID , T.TASK_NUMBER || ' - ' || PRE.COST_CODE , T.TASK_NAME || ' - ' || PRE.COST_CODE_NAME , T.START_DATE , T.COMPLETION_DATE , T.CHARGEABLE_FLAG , T.billable_flag , IMP.ORG_ID , T.TASK_NUMBER || '-' || T.TASK_NAME TASK_DETAILS , AT.CBS_ELEMENT_ID , PRE.COST_CODE , PRE.COST_CODE_NAME , T.TASK_ID , T.TOP_TASK_ID , T.TASK_MANAGER_PERSON_ID FROM PA_TASKS T, PA_PROJECTS_ALL P, PA_IMPLEMENTATIONS IMP, PA_LOOKUPS LU, PA_ALTERNATE_TASKS AT, PA_RBS_ELEMENTS PRE WHERE LU.LOOKUP_TYPE = 'PA_TASKS_TO_DISPLAY' AND LU.LOOKUP_CODE = NVL(FND_PROFILE.VALUE('PA_TASKS_DISPLAYED'),'ALL') AND (( LU.LOOKUP_CODE = 'CHARGEABLE' AND T.CHARGEABLE_FLAG = 'Y') OR ( LU.LOOKUP_CODE = 'ALL') OR (LU.LOOKUP_CODE = 'LOWEST' AND PA_TASK_UTILS.CHECK_CHILD_EXISTS(T.TASK_ID) = 0) ) AND (P.project_id = t.project_id AND( imp.org_id = p.org_id OR T.allow_cross_charge_flag = 'Y') AND NVL(P.CBS_ENABLE_FLAG, 'N') = 'Y') AND AT.proj_element_id = T.task_id AND PRE.RBS_ELEMENT_ID = AT.CBS_ELEMENT_ID AND PRE.RBS_VERSION_ID = P.CBS_VERSION_ID

View Text - HTML Formatted

SELECT T.PROJECT_ID
, P.SEGMENT1 PROJECT_NUMBER
, T.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, T.START_DATE
, T.COMPLETION_DATE
, T.CHARGEABLE_FLAG
, T.BILLABLE_FLAG
, IMP.ORG_ID
, T.TASK_NUMBER || '-' || T.TASK_NAME TASK_DETAILS
, NULL
, NULL
, NULL
, T.TASK_ID
, T.TOP_TASK_ID
, T.TASK_MANAGER_PERSON_ID
FROM PA_TASKS T
, PA_PROJECTS_ALL P
, PA_IMPLEMENTATIONS IMP
, PA_LOOKUPS LU
WHERE LU.LOOKUP_TYPE = 'PA_TASKS_TO_DISPLAY'
AND LU.LOOKUP_CODE = NVL(FND_PROFILE.VALUE('PA_TASKS_DISPLAYED')
, 'ALL')
AND (( LU.LOOKUP_CODE = 'CHARGEABLE'
AND T.CHARGEABLE_FLAG = 'Y') OR ( LU.LOOKUP_CODE = 'ALL') OR (LU.LOOKUP_CODE = 'LOWEST'
AND PA_TASK_UTILS.CHECK_CHILD_EXISTS(T.TASK_ID) = 0) )
AND (P.PROJECT_ID = T.PROJECT_ID AND( IMP.ORG_ID = P.ORG_ID OR T.ALLOW_CROSS_CHARGE_FLAG = 'Y')
AND NVL(P.CBS_ENABLE_FLAG
, 'N') = 'N') UNION SELECT T.PROJECT_ID
, P.SEGMENT1 PROJECT_NUMBER
, AT.ALT_TASK_ID
, T.TASK_NUMBER || ' - ' || PRE.COST_CODE
, T.TASK_NAME || ' - ' || PRE.COST_CODE_NAME
, T.START_DATE
, T.COMPLETION_DATE
, T.CHARGEABLE_FLAG
, T.BILLABLE_FLAG
, IMP.ORG_ID
, T.TASK_NUMBER || '-' || T.TASK_NAME TASK_DETAILS
, AT.CBS_ELEMENT_ID
, PRE.COST_CODE
, PRE.COST_CODE_NAME
, T.TASK_ID
, T.TOP_TASK_ID
, T.TASK_MANAGER_PERSON_ID
FROM PA_TASKS T
, PA_PROJECTS_ALL P
, PA_IMPLEMENTATIONS IMP
, PA_LOOKUPS LU
, PA_ALTERNATE_TASKS AT
, PA_RBS_ELEMENTS PRE
WHERE LU.LOOKUP_TYPE = 'PA_TASKS_TO_DISPLAY'
AND LU.LOOKUP_CODE = NVL(FND_PROFILE.VALUE('PA_TASKS_DISPLAYED')
, 'ALL')
AND (( LU.LOOKUP_CODE = 'CHARGEABLE'
AND T.CHARGEABLE_FLAG = 'Y') OR ( LU.LOOKUP_CODE = 'ALL') OR (LU.LOOKUP_CODE = 'LOWEST'
AND PA_TASK_UTILS.CHECK_CHILD_EXISTS(T.TASK_ID) = 0) )
AND (P.PROJECT_ID = T.PROJECT_ID AND( IMP.ORG_ID = P.ORG_ID OR T.ALLOW_CROSS_CHARGE_FLAG = 'Y')
AND NVL(P.CBS_ENABLE_FLAG
, 'N') = 'Y')
AND AT.PROJ_ELEMENT_ID = T.TASK_ID
AND PRE.RBS_ELEMENT_ID = AT.CBS_ELEMENT_ID
AND PRE.RBS_VERSION_ID = P.CBS_VERSION_ID