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 770: from msc_form_query

766: and s.supplier_id = l_supplier_id;
767:
768: cursor base_Model_exists( p_base_item NUMBER) is
769: select 1
770: from msc_form_query
771: where number8 = p_base_item
772: and query_id = p_query_id;
773:
774: model_exists NUMBER:= 2;

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

814: endPos := instr(p_supplier_list||',', ',',1,a);
815: end loop;
816:
817:
818: sql_stmt1 := 'INSERT INTO msc_form_query ( '||
819: 'query_id, '||
820: 'last_update_date, '||
821: 'last_updated_by, '||
822: 'creation_date, '||

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

866:
867: end if;
868:
869: if model_exists = 1 THEN
870: null; -- do not insert anything in msc_form_query
871: else
872:
873: -- This cursor will get me the list of all config/preconfigs which
874: -- have l_base_item as a base_item_id