APPS.MSC_CL_ROUTING_ODS_LOAD dependencies on MSC_ST_OPERATION_RESOURCES

Line 1935: FROM MSC_ST_OPERATION_RESOURCES msor

1931: msor.MINIMUM_CAPACITY,
1932: msor.MAXIMUM_CAPACITY ,
1933: msor.orig_resource_seq_num,
1934: msor.BREAKABLE_ACTIVITY_FLAG /*ds change change end */
1935: FROM MSC_ST_OPERATION_RESOURCES msor
1936: WHERE msor.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1937: AND msor.DELETED_FLAG= MSC_UTIL.SYS_NO;
1938:
1939: CURSOR c6_d IS

Line 1947: FROM MSC_ST_OPERATION_RESOURCES msor

1943: msor.RESOURCE_SEQ_NUM,
1944: msor.RESOURCE_ID,
1945: msor.ALTERNATE_NUMBER,
1946: msor.SR_INSTANCE_ID
1947: FROM MSC_ST_OPERATION_RESOURCES msor
1948: WHERE msor.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1949: AND msor.DELETED_FLAG= MSC_UTIL.SYS_YES;
1950:
1951: CURSOR c6_corrupt_data IS

Line 1956: FROM MSC_ST_OPERATION_RESOURCES msor

1952: SELECT
1953: msor.ROUTING_SEQUENCE_ID,
1954: msor.RESOURCE_ID,
1955: msor.RESOURCE_SEQ_NUM
1956: FROM MSC_ST_OPERATION_RESOURCES msor
1957: WHERE msor.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1958: AND msor.DELETED_FLAG= MSC_UTIL.SYS_NO
1959: AND nvl(msor.RESOURCE_SEQ_NUM,0)=0
1960: AND msor.ALTERNATE_NUMBER > 0;

Line 2049: ||' FROM MSC_ST_OPERATION_RESOURCES msor'

2045: ||' :v_current_date, '
2046: ||' :v_current_user, '
2047: ||' :v_current_date, '
2048: ||' :v_current_user '
2049: ||' FROM MSC_ST_OPERATION_RESOURCES msor'
2050: ||' WHERE msor.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
2051: ||' AND msor.DELETED_FLAG= '||MSC_UTIL.SYS_NO
2052: ||' AND NOT(nvl(msor.RESOURCE_SEQ_NUM,0)=0 AND msor.ALTERNATE_NUMBER > 0)';
2053: