APPS.MSC_CL_ROUTING_ODS_LOAD dependencies on MSC_ST_OPERATION_RESOURCES

Line 1941: FROM MSC_ST_OPERATION_RESOURCES msor

1937: msor.MINIMUM_CAPACITY,
1938: msor.MAXIMUM_CAPACITY ,
1939: msor.orig_resource_seq_num,
1940: msor.BREAKABLE_ACTIVITY_FLAG /*ds change change end */
1941: FROM MSC_ST_OPERATION_RESOURCES msor
1942: WHERE msor.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1943: AND msor.DELETED_FLAG= MSC_UTIL.SYS_NO;
1944:
1945: CURSOR c6_d IS

Line 1953: FROM MSC_ST_OPERATION_RESOURCES msor

1949: msor.RESOURCE_SEQ_NUM,
1950: msor.RESOURCE_ID,
1951: msor.ALTERNATE_NUMBER,
1952: msor.SR_INSTANCE_ID
1953: FROM MSC_ST_OPERATION_RESOURCES msor
1954: WHERE msor.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1955: AND msor.DELETED_FLAG= MSC_UTIL.SYS_YES;
1956:
1957: CURSOR c6_corrupt_data IS

Line 1962: FROM MSC_ST_OPERATION_RESOURCES msor

1958: SELECT
1959: msor.ROUTING_SEQUENCE_ID,
1960: msor.RESOURCE_ID,
1961: msor.RESOURCE_SEQ_NUM
1962: FROM MSC_ST_OPERATION_RESOURCES msor
1963: WHERE msor.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1964: AND msor.DELETED_FLAG= MSC_UTIL.SYS_NO
1965: AND nvl(msor.RESOURCE_SEQ_NUM,0)=0
1966: AND msor.ALTERNATE_NUMBER > 0;

Line 2055: ||' FROM MSC_ST_OPERATION_RESOURCES msor'

2051: ||' :v_current_date, '
2052: ||' :v_current_user, '
2053: ||' :v_current_date, '
2054: ||' :v_current_user '
2055: ||' FROM MSC_ST_OPERATION_RESOURCES msor'
2056: ||' WHERE msor.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
2057: ||' AND msor.DELETED_FLAG= '||MSC_UTIL.SYS_NO
2058: ||' AND NOT(nvl(msor.RESOURCE_SEQ_NUM,0)=0 AND msor.ALTERNATE_NUMBER > 0)';
2059: