APPS.MSC_X_EX5_PKG dependencies on MSC_X_ITEM_ORGS_GTT

Line 96: MSC_X_ITEM_ORGS_GTT iot,

92: itm.sr_instance_id
93: FROM msc_sup_dem_entries_v sd,
94: msc_item_suppliers itm,
95: MSC_X_ITEM_SUPPLIERS_GTT iut,
96: MSC_X_ITEM_ORGS_GTT iot,
97: MSC_X_ITEM_SITES_GTT ist
98: WHERE sd.plan_id = MSC_X_NETTING_PKG.G_PLAN_ID
99: AND sd.publisher_order_type = 15 -- ASN
100: AND sd.vmi_flag = 1

Line 131: MSC_X_ITEM_ORGS_GTT iot,

127: FROM msc_item_suppliers itm,
128: msc_trading_partners tp2 ,
129: msc_trading_partner_sites tps,
130: MSC_X_ITEM_SUPPLIERS_GTT iut,
131: MSC_X_ITEM_ORGS_GTT iot,
132: MSC_X_ITEM_SITES_GTT ist
133: WHERE itm.plan_id = MSC_X_NETTING_PKG.G_PLAN_ID
134: AND itm.organization_id = iot.sr_tp_id
135: AND itm.supplier_id = iut.tp_key

Line 151: MSC_X_ITEM_ORGS_GTT iot,

147: AND itm.inventory_item_id NOT IN ( select distinct sd.inventory_item_id
148: FROM msc_sup_dem_entries_v sd,
149: msc_item_suppliers itm,
150: MSC_X_ITEM_SUPPLIERS_GTT iut,
151: MSC_X_ITEM_ORGS_GTT iot,
152: MSC_X_ITEM_SITES_GTT ist
153: WHERE sd.plan_id = -1
154: AND sd.publisher_order_type IN (15, 9, 13, 16, 20) -- ASN , Onhand, PO, Rcpt, Req
155: AND sd.vmi_flag = 1

Line 192: MSC_X_ITEM_ORGS_GTT iot,

188: itm.sr_instance_id
189: FROM msc_sup_dem_entries_v sd,
190: msc_item_suppliers itm,
191: MSC_X_ITEM_SUPPLIERS_GTT iut,
192: MSC_X_ITEM_ORGS_GTT iot,
193: MSC_X_ITEM_SITES_GTT ist
194: WHERE sd.plan_id = MSC_X_NETTING_PKG.G_PLAN_ID
195: AND sd.publisher_order_type IN (9, 13, 16, 20) -- Onhand, PO, Rcpt, Req
196: AND sd.vmi_flag = 1