APPS.MSC_X_NETTING3_PKG dependencies on MSC_COMPANY_SITES

Line 447: msc_company_sites s,

443: P_SUPP_SITE_ID IN NUMBER) IS
444: SELECT SUP.TRANSACTION_ID -- the 1st level of po transaction id in ASCP
445: FROM msc_supplies sup,
446: msc_companies c,
447: msc_company_sites s,
448: msc_trading_partners t,
449: msc_trading_partner_maps m
450: WHERE sup.plan_id = P_PLAN_ID
451: AND decode(instr(sup.order_number,'('),0, sup.order_number,substr(sup.order_number, 1, instr(sup.order_number,'(') - 1)) = P_ORDER_NUMBER

Line 2714: msc_company_sites s1,

2710: l_customer_item_name,
2711: l_customer_item_desc
2712: FROM msc_supplies sup,
2713: msc_companies c1,
2714: msc_company_sites s1,
2715: msc_trading_partners t1,
2716: msc_trading_partner_maps m1,
2717: msc_trading_partners t2,
2718: msc_trading_partner_maps m2,

Line 2720: msc_company_sites s2,

2716: msc_trading_partner_maps m1,
2717: msc_trading_partners t2,
2718: msc_trading_partner_maps m2,
2719: msc_companies c2,
2720: msc_company_sites s2,
2721: msc_company_relationships rel,
2722: msc_trading_partner_maps m3,
2723: msc_sup_dem_entries sd
2724: WHERE sup.transaction_id = l_peg_trx_id

Line 3007: msc_company_sites s1,

3003: l_customer_item_name,
3004: l_customer_item_desc
3005: FROM msc_demands dem,
3006: msc_companies c1,
3007: msc_company_sites s1,
3008: msc_trading_partners t1,
3009: msc_trading_partner_maps m1,
3010: msc_trading_partners t2,
3011: msc_trading_partner_maps m2,

Line 3013: msc_company_sites s2,

3009: msc_trading_partner_maps m1,
3010: msc_trading_partners t2,
3011: msc_trading_partner_maps m2,
3012: msc_companies c2,
3013: msc_company_sites s2,
3014: msc_company_relationships rel,
3015: msc_trading_partner_maps m3,
3016: msc_sup_dem_entries sd,
3017: msc_sales_orders mso