APPS.MSC_SUPPLIER_HORIZONTAL_PLAN dependencies on MSC_TRADING_PARTNER_SITES

Line 134: msc_trading_partner_sites mtp

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)
136: AND mr.disposition_status_type <> 2
137: AND decode(mtp.shipping_control,'BUYER',mr.new_ship_date,mr.new_dock_date) <= trunc(g_cutoff_date)
138: AND decode(mtp.shipping_control,'BUYER',mr.new_ship_date,mr.new_dock_date) >= trunc(g_plan_start_date+1)

Line 193: msc_trading_partner_sites mtp

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
196: AND decode(mtp.shipping_control,'BUYER',mr.new_ship_date,mr.new_dock_date) <= trunc(g_cutoff_date)
197: AND decode(mtp.shipping_control,'BUYER',mr.new_ship_date,mr.new_dock_date) >= trunc(g_plan_start_date+1)

Line 948: from msc_trading_partner_sites,mfg_lookups

944: l_shipping_control mfg_lookups.meaning%Type;
945:
946: CURSOR SUPPLIER_SITE_LABEL_C(p_supplier_site_id NUMBER) IS
947: select meaning,tp_site_code
948: from msc_trading_partner_sites,mfg_lookups
949: where partner_site_id=p_supplier_site_id
950: and lookup_type = 'MSC_ORDER_DATE_TYPE'
951: and lookup_code = decode(shipping_control,'BUYER',1,2);
952: