DBA Data[Home] [Help]

APPS.CSF_GANTT_DATA_PKG dependencies on CAC_SR_OBJECT_CAPACITY

Line 2408: FROM cac_sr_object_capacity ca,(SELECT TO_NUMBER(

2404: , start_date_time
2405: , end_date_time
2406: , status blocked_trip
2407: , res_info.resource_id||'-'||res_info.resource_type resource_key
2408: FROM cac_sr_object_capacity ca,(SELECT TO_NUMBER(
2409: SUBSTR(column_value
2410: , 1
2411: , INSTR(column_value, '-', 1, 1) - 1
2412: )

Line 3729: FROM cac_sr_object_capacity ca

3725: , ca.start_date_time
3726: , ca.end_date_time
3727: , status blocked_trip
3728: , resource_id
3729: FROM cac_sr_object_capacity ca
3730: , (SELECT resource_id || '-' || resource_type || '-' || plan_option_id
3731: resource_id
3732: , object_capacity_id
3733: , resource_id res_id