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_EXCHANGE_BUCKETING dependencies on MSC_X_NETTING_PKG

Line 2245: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID

2241: sd.publisher_id supplier_id,
2242: sd.publisher_site_id supplier_site_id,
2243: nvl(sd.base_item_id,sd.inventory_item_id) item_id
2244: FROM msc_sup_dem_entries sd
2245: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
2246: AND sd.publisher_order_type in (msc_x_netting_pkg.SUPPLY_COMMIT, msc_x_netting_pkg.SALES_ORDER)
2247: AND sd.last_refresh_number > p_refresh_number
2248: union
2249: SELECT distinct sd.publisher_id customer_id,

Line 2246: AND sd.publisher_order_type in (msc_x_netting_pkg.SUPPLY_COMMIT, msc_x_netting_pkg.SALES_ORDER)

2242: sd.publisher_site_id supplier_site_id,
2243: nvl(sd.base_item_id,sd.inventory_item_id) item_id
2244: FROM msc_sup_dem_entries sd
2245: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
2246: AND sd.publisher_order_type in (msc_x_netting_pkg.SUPPLY_COMMIT, msc_x_netting_pkg.SALES_ORDER)
2247: AND sd.last_refresh_number > p_refresh_number
2248: union
2249: SELECT distinct sd.publisher_id customer_id,
2250: sd.publisher_site_id customer_site_id,

Line 2255: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID

2251: sd.supplier_id,
2252: sd.supplier_site_id,
2253: nvl(sd.base_item_id,sd.inventory_item_id) item_id
2254: FROM msc_sup_dem_entries sd
2255: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
2256: AND sd.publisher_order_type = msc_x_netting_pkg.ORDER_FORECAST
2257: AND sd.last_refresh_number> p_refresh_number;
2258:
2259: /* These cursors c2 and c3 are not used at all .

Line 2256: AND sd.publisher_order_type = msc_x_netting_pkg.ORDER_FORECAST

2252: sd.supplier_site_id,
2253: nvl(sd.base_item_id,sd.inventory_item_id) item_id
2254: FROM msc_sup_dem_entries sd
2255: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
2256: AND sd.publisher_order_type = msc_x_netting_pkg.ORDER_FORECAST
2257: AND sd.last_refresh_number> p_refresh_number;
2258:
2259: /* These cursors c2 and c3 are not used at all .
2260: These were alternatives tried for performance gains */

Line 2456: msc_x_netting_pkg.SUPPLY_PLANNING, ---.p_plan_type IN NUMBER,

2452: t_customer_site_sc(j) , ---p_customer_site_id IN NUMBER,
2453: t_supplier_sc(j) , ---p_supplier_id IN NUMBER,
2454: t_supplier_site_sc(j) , ---p_supplier_site_id IN NUMBER,
2455: t_item_id_sc(j), ----p_item_id IN NUMBER,
2456: msc_x_netting_pkg.SUPPLY_PLANNING, ---.p_plan_type IN NUMBER,
2457: t_max_ref_supp(j),
2458: t_max_receipt_supp(j),
2459: t_min_receipt_supp(j),
2460: t_max_ref_cust(j),

Line 2481: msc_x_netting_pkg.SUPPLY_PLANNING, --p_plan_type

2477: c_rec.customer_site_id, --p_customer_site_id
2478: c_rec.supplier_id, --p_supplier_id
2479: c_rec.supplier_site_id, --p_supplier_site_id
2480: c_rec.item_id, --p_item_id
2481: msc_x_netting_pkg.SUPPLY_PLANNING, --p_plan_type
2482: lv_cutoff_ref_num); --p_cutoff_ref_num
2483:
2484:
2485: exit when c1%NOTFOUND;