eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_X_RECEIVE_CAPACITY_PKG dependencies on MSC_SUP_DEM_ENTRIES

Line 42: FROM msc_sup_dem_entries_v sd,

38: --mis.DELIVERY_CALENDAR_CODE,
39: map2.tp_key, -- supplier_aps_id
40: map3.tp_key, -- supplier_site aps id
41: item1.ROUNDING_CONTROL_TYPE
42: FROM msc_sup_dem_entries_v sd,
43: msc_trading_partner_maps map1,
44: msc_trading_partners tp,
45: msc_system_items item,
46: msc_company_relationships cr,

Line 118: FROM msc_sup_dem_entries_v sd,

114: --mis.DELIVERY_CALENDAR_CODE,
115: map2.tp_key,
116: map3.tp_key,
117: item1.ROUNDING_CONTROL_TYPE
118: FROM msc_sup_dem_entries_v sd,
119: msc_trading_partner_maps map1,
120: msc_trading_partners tp,
121: msc_system_items item,
122: MSC_CAL_WEEK_START_DATES mcd,

Line 202: FROM msc_sup_dem_entries_v sd,

198: --mis.DELIVERY_CALENDAR_CODE,
199: map2.tp_key,
200: map3.tp_key,
201: item1.ROUNDING_CONTROL_TYPE
202: FROM msc_sup_dem_entries_v sd,
203: msc_trading_partner_maps map1,
204: msc_trading_partners tp,
205: msc_system_items item,
206: MSC_PERIOD_START_DATES mpd,

Line 273: FROM msc_sup_dem_entries_v sd,

269: p_sce_supplier_id IN NUMBER,
270: p_sce_supplier_site_id IN NUMBER,
271: p_bucket_type IN NUMBER) IS
272: SELECT sum(sd.tp_quantity)
273: FROM msc_sup_dem_entries_v sd,
274: msc_trading_partner_maps map1,
275: msc_trading_partners tp,
276: msc_system_items item
277: WHERE sd.plan_id = -1

Line 324: l_sce_supplier_id msc_sup_dem_entries.publisher_id%type;

320: p_overwrite in Number,
321: p_spread in number) IS
322:
323: l_sr_instance_id msc_trading_partners.sr_instance_id%type;
324: l_sce_supplier_id msc_sup_dem_entries.publisher_id%type;
325: l_sce_supplier_site_id msc_sup_dem_entries.publisher_site_id%type;
326: l_sce_supplier_name msc_sup_dem_entries.publisher_name%type;
327: l_sce_supplier_site_name msc_sup_dem_entries.publisher_site_name%type;
328: l_sce_customer_id msc_sup_dem_entries.customer_id%type;

Line 325: l_sce_supplier_site_id msc_sup_dem_entries.publisher_site_id%type;

321: p_spread in number) IS
322:
323: l_sr_instance_id msc_trading_partners.sr_instance_id%type;
324: l_sce_supplier_id msc_sup_dem_entries.publisher_id%type;
325: l_sce_supplier_site_id msc_sup_dem_entries.publisher_site_id%type;
326: l_sce_supplier_name msc_sup_dem_entries.publisher_name%type;
327: l_sce_supplier_site_name msc_sup_dem_entries.publisher_site_name%type;
328: l_sce_customer_id msc_sup_dem_entries.customer_id%type;
329: l_sce_customer_site_id msc_sup_dem_entries.customer_site_id%type;

Line 326: l_sce_supplier_name msc_sup_dem_entries.publisher_name%type;

322:
323: l_sr_instance_id msc_trading_partners.sr_instance_id%type;
324: l_sce_supplier_id msc_sup_dem_entries.publisher_id%type;
325: l_sce_supplier_site_id msc_sup_dem_entries.publisher_site_id%type;
326: l_sce_supplier_name msc_sup_dem_entries.publisher_name%type;
327: l_sce_supplier_site_name msc_sup_dem_entries.publisher_site_name%type;
328: l_sce_customer_id msc_sup_dem_entries.customer_id%type;
329: l_sce_customer_site_id msc_sup_dem_entries.customer_site_id%type;
330: l_sce_customer_name msc_sup_dem_entries.customer_name%type;

Line 327: l_sce_supplier_site_name msc_sup_dem_entries.publisher_site_name%type;

323: l_sr_instance_id msc_trading_partners.sr_instance_id%type;
324: l_sce_supplier_id msc_sup_dem_entries.publisher_id%type;
325: l_sce_supplier_site_id msc_sup_dem_entries.publisher_site_id%type;
326: l_sce_supplier_name msc_sup_dem_entries.publisher_name%type;
327: l_sce_supplier_site_name msc_sup_dem_entries.publisher_site_name%type;
328: l_sce_customer_id msc_sup_dem_entries.customer_id%type;
329: l_sce_customer_site_id msc_sup_dem_entries.customer_site_id%type;
330: l_sce_customer_name msc_sup_dem_entries.customer_name%type;
331: l_sce_customer_site_name msc_sup_dem_entries.customer_site_name%type;

Line 328: l_sce_customer_id msc_sup_dem_entries.customer_id%type;

324: l_sce_supplier_id msc_sup_dem_entries.publisher_id%type;
325: l_sce_supplier_site_id msc_sup_dem_entries.publisher_site_id%type;
326: l_sce_supplier_name msc_sup_dem_entries.publisher_name%type;
327: l_sce_supplier_site_name msc_sup_dem_entries.publisher_site_name%type;
328: l_sce_customer_id msc_sup_dem_entries.customer_id%type;
329: l_sce_customer_site_id msc_sup_dem_entries.customer_site_id%type;
330: l_sce_customer_name msc_sup_dem_entries.customer_name%type;
331: l_sce_customer_site_name msc_sup_dem_entries.customer_site_name%type;
332: l_sce_company_id msc_companies.company_id%type;

Line 329: l_sce_customer_site_id msc_sup_dem_entries.customer_site_id%type;

325: l_sce_supplier_site_id msc_sup_dem_entries.publisher_site_id%type;
326: l_sce_supplier_name msc_sup_dem_entries.publisher_name%type;
327: l_sce_supplier_site_name msc_sup_dem_entries.publisher_site_name%type;
328: l_sce_customer_id msc_sup_dem_entries.customer_id%type;
329: l_sce_customer_site_id msc_sup_dem_entries.customer_site_id%type;
330: l_sce_customer_name msc_sup_dem_entries.customer_name%type;
331: l_sce_customer_site_name msc_sup_dem_entries.customer_site_name%type;
332: l_sce_company_id msc_companies.company_id%type;
333: l_map_supplier_id msc_sup_dem_entries.publisher_id%type;

Line 330: l_sce_customer_name msc_sup_dem_entries.customer_name%type;

326: l_sce_supplier_name msc_sup_dem_entries.publisher_name%type;
327: l_sce_supplier_site_name msc_sup_dem_entries.publisher_site_name%type;
328: l_sce_customer_id msc_sup_dem_entries.customer_id%type;
329: l_sce_customer_site_id msc_sup_dem_entries.customer_site_id%type;
330: l_sce_customer_name msc_sup_dem_entries.customer_name%type;
331: l_sce_customer_site_name msc_sup_dem_entries.customer_site_name%type;
332: l_sce_company_id msc_companies.company_id%type;
333: l_map_supplier_id msc_sup_dem_entries.publisher_id%type;
334: l_map_supplier_site_id msc_sup_dem_entries.publisher_site_id%type;

Line 331: l_sce_customer_site_name msc_sup_dem_entries.customer_site_name%type;

327: l_sce_supplier_site_name msc_sup_dem_entries.publisher_site_name%type;
328: l_sce_customer_id msc_sup_dem_entries.customer_id%type;
329: l_sce_customer_site_id msc_sup_dem_entries.customer_site_id%type;
330: l_sce_customer_name msc_sup_dem_entries.customer_name%type;
331: l_sce_customer_site_name msc_sup_dem_entries.customer_site_name%type;
332: l_sce_company_id msc_companies.company_id%type;
333: l_map_supplier_id msc_sup_dem_entries.publisher_id%type;
334: l_map_supplier_site_id msc_sup_dem_entries.publisher_site_id%type;
335: l_item_id msc_sup_dem_entries.inventory_item_id%type;

Line 333: l_map_supplier_id msc_sup_dem_entries.publisher_id%type;

329: l_sce_customer_site_id msc_sup_dem_entries.customer_site_id%type;
330: l_sce_customer_name msc_sup_dem_entries.customer_name%type;
331: l_sce_customer_site_name msc_sup_dem_entries.customer_site_name%type;
332: l_sce_company_id msc_companies.company_id%type;
333: l_map_supplier_id msc_sup_dem_entries.publisher_id%type;
334: l_map_supplier_site_id msc_sup_dem_entries.publisher_site_id%type;
335: l_item_id msc_sup_dem_entries.inventory_item_id%type;
336: l_item_name msc_items.item_name%type;
337: l_uom_code msc_sup_dem_entries.uom_code%type;

Line 334: l_map_supplier_site_id msc_sup_dem_entries.publisher_site_id%type;

330: l_sce_customer_name msc_sup_dem_entries.customer_name%type;
331: l_sce_customer_site_name msc_sup_dem_entries.customer_site_name%type;
332: l_sce_company_id msc_companies.company_id%type;
333: l_map_supplier_id msc_sup_dem_entries.publisher_id%type;
334: l_map_supplier_site_id msc_sup_dem_entries.publisher_site_id%type;
335: l_item_id msc_sup_dem_entries.inventory_item_id%type;
336: l_item_name msc_items.item_name%type;
337: l_uom_code msc_sup_dem_entries.uom_code%type;
338: l_receipt_date msc_sup_dem_entries.receipt_date%type;

Line 335: l_item_id msc_sup_dem_entries.inventory_item_id%type;

331: l_sce_customer_site_name msc_sup_dem_entries.customer_site_name%type;
332: l_sce_company_id msc_companies.company_id%type;
333: l_map_supplier_id msc_sup_dem_entries.publisher_id%type;
334: l_map_supplier_site_id msc_sup_dem_entries.publisher_site_id%type;
335: l_item_id msc_sup_dem_entries.inventory_item_id%type;
336: l_item_name msc_items.item_name%type;
337: l_uom_code msc_sup_dem_entries.uom_code%type;
338: l_receipt_date msc_sup_dem_entries.receipt_date%type;
339: l_sr_tp_id msc_trading_partners.sr_tp_id%type;

Line 337: l_uom_code msc_sup_dem_entries.uom_code%type;

333: l_map_supplier_id msc_sup_dem_entries.publisher_id%type;
334: l_map_supplier_site_id msc_sup_dem_entries.publisher_site_id%type;
335: l_item_id msc_sup_dem_entries.inventory_item_id%type;
336: l_item_name msc_items.item_name%type;
337: l_uom_code msc_sup_dem_entries.uom_code%type;
338: l_receipt_date msc_sup_dem_entries.receipt_date%type;
339: l_sr_tp_id msc_trading_partners.sr_tp_id%type;
340: l_modeled_supplier_id msc_trading_partners.modeled_supplier_id%type;
341: l_modeled_supplier_site_id msc_trading_partners.modeled_supplier_site_id%type;

Line 338: l_receipt_date msc_sup_dem_entries.receipt_date%type;

334: l_map_supplier_site_id msc_sup_dem_entries.publisher_site_id%type;
335: l_item_id msc_sup_dem_entries.inventory_item_id%type;
336: l_item_name msc_items.item_name%type;
337: l_uom_code msc_sup_dem_entries.uom_code%type;
338: l_receipt_date msc_sup_dem_entries.receipt_date%type;
339: l_sr_tp_id msc_trading_partners.sr_tp_id%type;
340: l_modeled_supplier_id msc_trading_partners.modeled_supplier_id%type;
341: l_modeled_supplier_site_id msc_trading_partners.modeled_supplier_site_id%type;
342: l_calendar_code msc_trading_partners.calendar_code%type;

Line 347: l_bucket_type msc_sup_dem_entries.bucket_type%type;

343: l_aps_organization_id msc_item_suppliers.organization_id%type;
344: l_aps_supplier_id msc_item_suppliers.supplier_id%type;
345: l_aps_supplier_site_id msc_item_suppliers.supplier_site_id%type;
346: l_rounding_control number;
347: l_bucket_type msc_sup_dem_entries.bucket_type%type;
348: l_org_code msc_trading_partners.organization_code%type;
349: l_plan_id Number := -1; --ods load
350: l_collected_flag Number := 3; --means from destination
351: l_capacity Number;