DBA Data[Home] [Help]

APPS.MSC_ATP_CTO dependencies on MSC_SHIP_SET_TEMP

Line 794: msc_ship_set_temp msst

790: ---first find out how many items have OSS specific rules
791: select count(distinct mcs.line_id)
792: into l_item_count
793: from msc_cto_sources mcs,
794: msc_ship_set_temp msst
795: where mcs.line_id = msst.line_id
796: and mcs.sr_instance_id = p_instance_id
797: --and mcs.status_flag = 1;
798: and session_id = p_session_id;

Line 822: msc_ship_set_temp msst

818: l_line_id,
819: l_org_id,
820: l_sup_id
821: from msc_cto_sources mcs,
822: msc_ship_set_temp msst
823: where mcs.line_id = msst.line_id
824: and mcs.sr_instance_id = p_instance_id
825: --and mcs.status_flag = 1;
826: and mcs.session_id = p_session_id;

Line 846: msc_ship_set_temp msst

842: l_cto_source_list.supplier_id,
843: l_cto_source_list.supplier_site_id,
844: l_cto_source_list.make_flag
845: from msc_cto_sources mcs,
846: msc_ship_set_temp msst
847: where mcs.line_id = msst.line_id
848: and mcs.sr_instance_id = p_instance_id
849: --and mcs.status_flag = 1
850: and mcs.session_id = p_session_id