VIEW: APPS.PA_WBS_V

Source

View Text - Preformatted

SELECT DISTINCT(TASK.TASK_NUMBER) , TASK.ROWID ROW_ID , TASK.TASK_ID , TASK.PROJECT_ID , TASK.CREATION_DATE , TASK.CREATED_BY , TASK.LAST_UPDATE_DATE , TASK.LAST_UPDATED_BY , TASK.LAST_UPDATE_LOGIN , TASK.TASK_NAME , TASK.LONG_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 , TASK.SERVICE_TYPE_CODE , TASK.TASK_MANAGER_PERSON_ID , TASK.CHARGEABLE_FLAG , TASK.BILLABLE_FLAG , TASK.LIMIT_TO_TXN_CONTROLS_FLAG , TASK.START_DATE , TASK.COMPLETION_DATE , TASK.ADDRESS_ID , 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 , PA_TASK_UTILS.SORT_ORDER_TREE_WALK(TASK.PARENT_TASK_ID, TASK.TASK_NUMBER) , DECODE(PA_TASK_UTILS.CHECK_CHILD_EXISTS(TASK.TASK_ID), 1,'+',0,' ') , 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 , 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 START WITH TASK.TASK_ID IN ( SELECT TASK_ID FROM PA_TASKS P WHERE P.TASK_NUMBER LIKE NVL(PA_WBS_PKG.GET_TASK_NUMBER, P.TASK_NUMBER) AND P.TASK_NAME LIKE NVL(PA_WBS_PKG.GET_TASK_NAME, P.TASK_NAME) AND NVL(P.PM_TASK_REFERENCE, ' ') LIKE NVL(NVL(PA_WBS_PKG.GET_TASK_REFERENCE, P.PM_TASK_REFERENCE), ' ') AND NVL(P.CHARGEABLE_FLAG, ' ') = NVL(NVL(PA_WBS_PKG.GET_CHARGEABLE_FLAG, P.CHARGEABLE_FLAG), ' ') AND NVL(P.BILLABLE_FLAG, ' ') = NVL(NVL(PA_WBS_PKG.GET_BILLABLE_FLAG, P.BILLABLE_FLAG), ' ') AND NVL(P.TASK_MANAGER_PERSON_ID, -99) = NVL(NVL(PA_WBS_PKG.GET_MANAGER_ID , P.TASK_MANAGER_PERSON_ID), -99) AND P.CARRYING_OUT_ORGANIZATION_ID = NVL(PA_WBS_PKG.GET_ORGANIZATION_ID, P.CARRYING_OUT_ORGANIZATION_ID) AND P.WBS_LEVEL = NVL(PA_WBS_PKG.GET_WBS_LEVEL, P.WBS_LEVEL) AND NVL(P.SERVICE_TYPE_CODE, ' ') = NVL(NVL(PA_WBS_PKG.GET_SERVICE_CODE, P.SERVICE_TYPE_CODE), ' ') AND NVL(P.PM_PRODUCT_CODE, ' ') = NVL(NVL(PA_WBS_PKG.GET_PRODUCT_CODE, P.PM_PRODUCT_CODE), ' ') AND P.PROJECT_ID = PA_WBS_PKG.GET_PROJECT_ID ) CONNECT BY PRIOR TASK.PARENT_TASK_ID = TASK.TASK_ID

View Text - HTML Formatted

SELECT DISTINCT(TASK.TASK_NUMBER)
, TASK.ROWID ROW_ID
, TASK.TASK_ID
, TASK.PROJECT_ID
, TASK.CREATION_DATE
, TASK.CREATED_BY
, TASK.LAST_UPDATE_DATE
, TASK.LAST_UPDATED_BY
, TASK.LAST_UPDATE_LOGIN
, TASK.TASK_NAME
, TASK.LONG_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
, TASK.SERVICE_TYPE_CODE
, TASK.TASK_MANAGER_PERSON_ID
, TASK.CHARGEABLE_FLAG
, TASK.BILLABLE_FLAG
, TASK.LIMIT_TO_TXN_CONTROLS_FLAG
, TASK.START_DATE
, TASK.COMPLETION_DATE
, TASK.ADDRESS_ID
, 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
, PA_TASK_UTILS.SORT_ORDER_TREE_WALK(TASK.PARENT_TASK_ID
, TASK.TASK_NUMBER)
, DECODE(PA_TASK_UTILS.CHECK_CHILD_EXISTS(TASK.TASK_ID)
, 1
, '+'
, 0
, ' ')
, 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
, 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 START WITH TASK.TASK_ID IN ( SELECT TASK_ID
FROM PA_TASKS P
WHERE P.TASK_NUMBER LIKE NVL(PA_WBS_PKG.GET_TASK_NUMBER
, P.TASK_NUMBER)
AND P.TASK_NAME LIKE NVL(PA_WBS_PKG.GET_TASK_NAME
, P.TASK_NAME)
AND NVL(P.PM_TASK_REFERENCE
, ' ') LIKE NVL(NVL(PA_WBS_PKG.GET_TASK_REFERENCE
, P.PM_TASK_REFERENCE)
, ' ')
AND NVL(P.CHARGEABLE_FLAG
, ' ') = NVL(NVL(PA_WBS_PKG.GET_CHARGEABLE_FLAG
, P.CHARGEABLE_FLAG)
, ' ')
AND NVL(P.BILLABLE_FLAG
, ' ') = NVL(NVL(PA_WBS_PKG.GET_BILLABLE_FLAG
, P.BILLABLE_FLAG)
, ' ')
AND NVL(P.TASK_MANAGER_PERSON_ID
, -99) = NVL(NVL(PA_WBS_PKG.GET_MANAGER_ID
, P.TASK_MANAGER_PERSON_ID)
, -99)
AND P.CARRYING_OUT_ORGANIZATION_ID = NVL(PA_WBS_PKG.GET_ORGANIZATION_ID
, P.CARRYING_OUT_ORGANIZATION_ID)
AND P.WBS_LEVEL = NVL(PA_WBS_PKG.GET_WBS_LEVEL
, P.WBS_LEVEL)
AND NVL(P.SERVICE_TYPE_CODE
, ' ') = NVL(NVL(PA_WBS_PKG.GET_SERVICE_CODE
, P.SERVICE_TYPE_CODE)
, ' ')
AND NVL(P.PM_PRODUCT_CODE
, ' ') = NVL(NVL(PA_WBS_PKG.GET_PRODUCT_CODE
, P.PM_PRODUCT_CODE)
, ' ')
AND P.PROJECT_ID = PA_WBS_PKG.GET_PROJECT_ID ) CONNECT BY PRIOR TASK.PARENT_TASK_ID = TASK.TASK_ID