VIEW: APPS.PA_TASKS_AMG_V

Source

View Text - Preformatted

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.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 ,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.REVENUE_ACCRUAL_METHOD ,TASK.INVOICE_METHOD ,TASK.CUSTOMER_ID FROM PA_TASKS TASK

View Text - HTML Formatted

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.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
, 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.REVENUE_ACCRUAL_METHOD
, TASK.INVOICE_METHOD
, TASK.CUSTOMER_ID
FROM PA_TASKS TASK