Product: | PA - Projects |
---|---|
Description: | 10Sc only |
Implementation/DBA Data: | APPS.PA_TASKS_V |
SELECT TASK.ROWID ROW_ID
, TASK.TASK_ID
, TASK.PROJECT_ID
, TASK.TASK_NUMBER
, TASK.CREATION_DATE
, TASK.CREATED_BY
, TASK.LAST_UPDATE_DATE
, TASK.LAST_UPDATED_BY
, TASK.LAST_UPDATE_LOGIN
, TASK.TASK_NAME
, TASK.TOP_TASK_ID
, TASK.WBS_LEVEL
, TASK.READY_TO_BILL_FLAG
, TASK.READY_TO_DISTRIBUTE_FLAG
, TASK.PARENT_TASK_ID
, TASK.DESCRIPTION
, TASK.CARRYING_OUT_ORGANIZATION_ID
, ORG.NAME ORGANIZATION_NAME
, TASK.SERVICE_TYPE_CODE
, LK.MEANING SERVICE_TYPE_M
, TASK.TASK_MANAGER_PERSON_ID
, EMP.FULL_NAME TASK_MANAGER_NAME
, TASK.CHARGEABLE_FLAG
, TASK.BILLABLE_FLAG
, TASK.LIMIT_TO_TXN_CONTROLS_FLAG
, TASK.START_DATE
, TASK.COMPLETION_DATE
, TASK.ADDRESS_ID
, L.ADDRESS1
, L.ADDRESS2
, L.ADDRESS3
, L.ADDRESS4
, L.CITY
, L.STATE
, L.COUNTRY
, TASK.LABOR_BILL_RATE_ORG_ID
, TASK.LABOR_STD_BILL_RATE_SCHDL
, TASK.LABOR_SCHEDULE_FIXED_DATE
, TASK.LABOR_SCHEDULE_DISCOUNT
, TASK.NON_LABOR_BILL_RATE_ORG_ID
, TASK.NON_LABOR_STD_BILL_RATE_SCHDL
, TASK.NON_LABOR_SCHEDULE_FIXED_DATE
, TASK.NON_LABOR_SCHEDULE_DISCOUNT
, TASK.LABOR_COST_MULTIPLIER_NAME
, TASK.REQUEST_ID
, TASK.PROGRAM_APPLICATION_ID
, TASK.PROGRAM_ID
, TASK.PROGRAM_UPDATE_DATE
, TASK.ATTRIBUTE_CATEGORY
, TASK.ATTRIBUTE1
, TASK.ATTRIBUTE2
, TASK.ATTRIBUTE3
, TASK.ATTRIBUTE4
, TASK.ATTRIBUTE5
, TASK.ATTRIBUTE6
, TASK.ATTRIBUTE7
, TASK.ATTRIBUTE8
, TASK.ATTRIBUTE9
, TASK.ATTRIBUTE10
, TASK.COST_IND_RATE_SCH_ID
, TASK.REV_IND_RATE_SCH_ID
, TASK.INV_IND_RATE_SCH_ID
, TASK.COST_IND_SCH_FIXED_DATE
, TASK.REV_IND_SCH_FIXED_DATE
, TASK.INV_IND_SCH_FIXED_DATE
, TASK.LABOR_SCH_TYPE
, TASK.NON_LABOR_SCH_TYPE
, TASK.PM_TASK_REFERENCE
, TASK.PM_PRODUCT_CODE
, LK2.MEANING
, DECODE(PA_TASK_UTILS.CHECK_CHILD_EXISTS(TASK.TASK_ID)
, 1
, '+'
, 0
, ' ')
, TASK.ACTUAL_START_DATE
, TASK.ACTUAL_FINISH_DATE
, TASK.EARLY_START_DATE
, TASK.EARLY_FINISH_DATE
, TASK.LATE_START_DATE
, TASK.LATE_FINISH_DATE
, TASK.SCHEDULED_START_DATE
, TASK.SCHEDULED_FINISH_DATE
, TASK.ALLOW_CROSS_CHARGE_FLAG
, TASK.PROJECT_RATE_DATE
, TASK.PROJECT_RATE_TYPE
, TASK.CC_PROCESS_LABOR_FLAG
, TASK.LABOR_TP_SCHEDULE_ID
, TASK.LABOR_TP_FIXED_DATE
, TASK.CC_PROCESS_NL_FLAG
, TASK.NL_TP_SCHEDULE_ID
, TASK.NL_TP_FIXED_DATE
, TASK.RECEIVE_PROJECT_INVOICE_FLAG
, TASK.WORK_TYPE_ID
, PWTV.NAME
, TASK.JOB_BILL_RATE_SCHEDULE_ID
, TASK.EMP_BILL_RATE_SCHEDULE_ID
, TASK.RECORD_VERSION_NUMBER
, TASK.TASKFUNC_COST_RATE_TYPE
, TASK.TASKFUNC_COST_RATE_DATE
, TASK.NON_LAB_STD_BILL_RT_SCH_ID
, TASK.LABOR_DISC_REASON_CODE
, TASK.NON_LABOR_DISC_REASON_CODE
, TASK.RETIREMENT_COST_FLAG
, TASK.CINT_ELIGIBLE_FLAG
, TASK.CINT_STOP_DATE
FROM PA_TASKS TASK
, HR_ORGANIZATION_UNITS ORG
, PER_ALL_PEOPLE_F EMP
, PA_LOOKUPS LK
, PA_LOOKUPS LK2
, PA_WORK_TYPES_VL PWTV
, HZ_CUST_ACCT_SITES_ALL S
, HZ_PARTY_SITES PS
, HZ_LOCATIONS L
WHERE TASK.CARRYING_OUT_ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND TASK.TASK_MANAGER_PERSON_ID = EMP.PERSON_ID (+)
AND NVL(EMP.EFFECTIVE_START_DATE
, TRUNC(SYSDATE)) = (SELECT NVL(MIN(PP.EFFECTIVE_START_DATE)
, TRUNC(SYSDATE))
FROM PER_ALL_PEOPLE_F PP
WHERE PP.PERSON_ID = EMP.PERSON_ID
AND PP.EFFECTIVE_END_DATE > TRUNC(SYSDATE))
AND TASK.SERVICE_TYPE_CODE = LK.LOOKUP_CODE(+)
AND LK.LOOKUP_TYPE(+) = 'SERVICE TYPE'
AND TASK.WORK_TYPE_ID = PWTV.WORK_TYPE_ID(+)
AND TASK.ADDRESS_ID = S.CUST_ACCT_SITE_ID(+)
AND PS.PARTY_SITE_ID(+) = S.PARTY_SITE_ID
AND L.LOCATION_ID(+) = PS.LOCATION_ID
AND TASK.PM_PRODUCT_CODE = LK2.LOOKUP_CODE(+)
AND LK2.LOOKUP_TYPE (+) = 'PM_PRODUCT_CODE'