DBA Data[Home] [Help]

APPS.MSC_GET_NAME dependencies on MSC_JOB_OPERATION_NETWORKS

Line 4268: from msc_job_operation_networks

4264: l_eam_parent_order_number number;
4265:
4266: cursor cur_parent_order is
4267: select to_transaction_id
4268: from msc_job_operation_networks
4269: where plan_id = p_plan_id
4270: and sr_instance_id = p_sr_instance_id
4271: and transaction_id = p_transaction_id
4272: and dependency_type = 3 ;

Line 4457: from msc_job_operation_networks

4453: select dependency_type,
4454: minimum_transfer_qty,
4455: minimum_time_offset,
4456: maximum_time_offset
4457: from msc_job_operation_networks
4458: where plan_id = p_plan_id
4459: and sr_instance_id = p_inst_id
4460: and transaction_id = p_trans_id
4461: and to_transaction_id = c_trans_id