APPS.MSC_SUPPLIER_HORIZONTAL_PLAN dependencies on MSC_FORM_QUERY

Line 82: msc_form_query list

78: msc_trading_partners mtp,
79: msc_calendar_dates cal,
80: msc_supplier_capacities cap,
81: msc_item_suppliers items,
82: msc_form_query list
83: WHERE
84: cap.supplier_id = list.number2
85: AND NVL(cap.supplier_site_id,-1) = NVL(list.number5,-1)
86: AND cap.plan_id = g_designator

Line 131: FROM msc_form_query list,

127: decode(g_use_sup_req,
128: 0, sum(mr.new_order_quantity),
129: 1, sum(msr.consumed_quantity)
130: )
131: FROM msc_form_query list,
132: msc_supplies mr,
133: msc_supplier_requirements msr,
134: msc_trading_partner_sites mtp
135: WHERE mr.order_type in (M_PLANNED_ORDER, M_PURCHASE_ORDER, M_PURCHASE_REQ, M_PLANNED_ARRIVAL)

Line 191: FROM msc_form_query list,

187: NULL, mr.new_order_quantity,
188: 0),
189: 0 ),
190: 0)) po_consumption_quantity
191: FROM msc_form_query list,
192: msc_supplies mr,
193: msc_trading_partner_sites mtp
194: WHERE mr.order_type = M_PURCHASE_ORDER
195: AND mr.disposition_status_type <> 2

Line 214: FROM msc_form_query list

210: AVAILABLE_HOURS,
211: g_plan_start_date,
212: null,
213: 0
214: FROM msc_form_query list
215: WHERE list.query_id = g_item_list_id
216: ORDER BY 1,2,3,5,4;
217:
218: -- =============================================================================

Line 781: from msc_form_query

777: and s.supplier_id = l_supplier_id;
778:
779: cursor base_Model_exists( p_base_item NUMBER) is
780: select 1
781: from msc_form_query
782: where number8 = p_base_item
783: and query_id = p_query_id;
784:
785: model_exists NUMBER:= 2;

Line 829: sql_stmt1 := 'INSERT INTO msc_form_query ( '||

825: endPos := instr(p_supplier_list||',', ',',1,a);
826: end loop;
827:
828:
829: sql_stmt1 := 'INSERT INTO msc_form_query ( '||
830: 'query_id, '||
831: 'last_update_date, '||
832: 'last_updated_by, '||
833: 'creation_date, '||

Line 881: null; -- do not insert anything in msc_form_query

877:
878: end if;
879:
880: if model_exists = 1 THEN
881: null; -- do not insert anything in msc_form_query
882: else
883:
884: -- This cursor will get me the list of all config/preconfigs which
885: -- have l_base_item as a base_item_id