APPS.MSC_CL_GMP_UTILITY dependencies on MSC_ST_JOB_OPERATION_NETWORKS

Line 10182: ' INSERT INTO msc_st_job_operation_networks '

10178:
10179:
10180: /* NAVIN: -- START: Complex Route -- Collect Batch Step Dependencies in one insert-select --*/
10181: sql_stmt :=
10182: ' INSERT INTO msc_st_job_operation_networks '
10183: || ' ( '
10184: || ' from_op_seq_id, '
10185: || ' to_op_seq_id, '
10186: || ' wip_entity_id, '

Line 10248: INSERT INTO msc_st_job_operation_networks(

10244: i := 1 ;
10245: log_message(stp_var_itm_from_op_seq_id.FIRST || ' *jonet*' || stp_var_itm_from_op_seq_id.LAST );
10246: IF stp_var_itm_from_op_seq_id.FIRST > 0 THEN
10247: FORALL i IN stp_var_itm_from_op_seq_id.FIRST..stp_var_itm_from_op_seq_id.LAST
10248: INSERT INTO msc_st_job_operation_networks(
10249: from_op_seq_id,
10250: wip_entity_id,
10251: dependency_type,
10252: transition_type,