DBA Data[Home] [Help]

APPS.MSC_X_NETTING3_PKG dependencies on MSC_COMPANIES

Line 446: msc_companies c,

442: P_SUPP_ID IN NUMBER,
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

Line 2713: msc_companies c1,

2709: l_customer_site_name,
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,

Line 2719: msc_companies c2,

2715: msc_trading_partners t1,
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

Line 3006: msc_companies c1,

3002: l_customer_site_name,
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,

Line 3012: msc_companies c2,

3008: msc_trading_partners t1,
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,