DBA Data[Home] [Help]

APPS.MSC_ATP_CTO dependencies on MSC_SHIP_SET_TEMP

Line 797: msc_ship_set_temp msst

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

Line 825: msc_ship_set_temp msst

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

Line 849: msc_ship_set_temp msst

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