DBA Data[Home] [Help]

APPS.MSC_GET_NAME dependencies on MSC_JOB_OPERATION_NETWORKS

Line 3811: from msc_job_operation_networks

3807: l_eam_parent_order_number number;
3808:
3809: cursor cur_parent_order is
3810: select to_transaction_id
3811: from msc_job_operation_networks
3812: where plan_id = p_plan_id
3813: and sr_instance_id = p_sr_instance_id
3814: and transaction_id = p_transaction_id
3815: and dependency_type = 3 ;

Line 4000: from msc_job_operation_networks

3996: select dependency_type,
3997: minimum_transfer_qty,
3998: minimum_time_offset,
3999: maximum_time_offset
4000: from msc_job_operation_networks
4001: where plan_id = p_plan_id
4002: and sr_instance_id = p_inst_id
4003: and transaction_id = p_trans_id
4004: and to_transaction_id = c_trans_id