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_ITEM_SUPPLIERS

Line 49: msc_item_suppliers mis,

45: msc_system_items item,
46: msc_company_relationships cr,
47: msc_trading_partner_maps map2,
48: msc_trading_partner_maps map3,
49: msc_item_suppliers mis,
50: msc_trading_partners tp2,
51: msc_system_items item1
52: WHERE sd.plan_id = -1
53: AND sd.publisher_order_type = SUPPLY_COMMIT

Line 126: msc_item_suppliers mis,

122: MSC_CAL_WEEK_START_DATES mcd,
123: msc_company_relationships cr,
124: msc_trading_partner_maps map2,
125: msc_trading_partner_maps map3,
126: msc_item_suppliers mis,
127: msc_trading_partners tp2,
128: msc_system_items item1
129: WHERE sd.plan_id = -1
130: AND sd.publisher_order_type = SUPPLY_COMMIT

Line 210: msc_item_suppliers mis,

206: MSC_PERIOD_START_DATES mpd,
207: msc_company_relationships cr,
208: msc_trading_partner_maps map2,
209: msc_trading_partner_maps map3,
210: msc_item_suppliers mis,
211: msc_trading_partners tp2,
212: msc_system_items item1
213: WHERE sd.plan_id = -1
214: AND sd.publisher_order_type = SUPPLY_COMMIT

Line 343: l_aps_organization_id msc_item_suppliers.organization_id%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;
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;

Line 344: l_aps_supplier_id msc_item_suppliers.supplier_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;
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;

Line 345: l_aps_supplier_site_id msc_item_suppliers.supplier_site_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;
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

Line 396: FROM msc_item_suppliers mis, msc_trading_partners tp

392: p_aps_supplier_id In Number,
393: p_aps_supplier_site_id In Number,
394: p_item_id In Number) IS
395: SELECT distinct mis.organization_id, tp.organization_code
396: FROM msc_item_suppliers mis, msc_trading_partners tp
397: WHERE plan_id = -1
398: AND mis.sr_instance_id = p_sr_instance_id
399: AND mis.supplier_id = p_aps_supplier_id
400: AND mis.supplier_site_id = p_aps_supplier_site_id

Line 654: msc_item_suppliers sup,

650: SELECT distinct tp.partner_id
651: INTO l_aps_supplier_id
652: FROM msc_trading_partner_maps map1,
653: msc_company_relationships rel,
654: msc_item_suppliers sup,
655: msc_trading_partners tp
656: WHERE rel.relationship_type =2 AND --supplier
657: rel.object_id = l_sce_supplier_id AND
658: rel.subject_id = 1 AND --other company (OEM)