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_NETTING3_PKG dependencies on MSC_SUPPLIES

Line 445: FROM msc_supplies sup,

441: P_CUST_SITE_ID IN NUMBER,
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

Line 1863: l_ascp_po_order_number msc_supplies.order_number%type;

1859: l_plan_order_at_risk_id number;
1860: l_demand_id Number;
1861: l_item_id Number;
1862:
1863: l_ascp_po_order_number msc_supplies.order_number%type;
1864: l_ascp_po_line msc_supplies.purch_line_num%type;
1865: l_cp_company_id Number;
1866: l_cp_company_site_id Number;
1867:

Line 1864: l_ascp_po_line msc_supplies.purch_line_num%type;

1860: l_demand_id Number;
1861: l_item_id Number;
1862:
1863: l_ascp_po_order_number msc_supplies.order_number%type;
1864: l_ascp_po_line msc_supplies.purch_line_num%type;
1865: l_cp_company_id Number;
1866: l_cp_company_site_id Number;
1867:
1868: l_peg_id Number;

Line 2712: FROM msc_supplies sup,

2708: l_customer_site_id,
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,