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.

[Home] [Help]

APPS.CSP_PLANNER_NOTIFICATIONS dependencies on MTL_SECONDARY_INVENTORIES

Line 1957: FROM mtl_secondary_inventories

1953: and sourcing_level not in (2,9));
1954:
1955: CURSOR u_wrhs_subinv_cur(p_orgn_id NUMBER) IS
1956: SELECT secondary_inventory_name
1957: FROM mtl_secondary_inventories
1958: WHERE organization_id = p_orgn_id
1959: AND availability_type = 1;
1960: /* AND secondary_inventory_name NOT IN
1961: (SELECT secondary_inventory_name

Line 2370: FROM mtl_secondary_inventories

2366: order by misl.rank;
2367:
2368: CURSOR d_wrhs_subinv_cur(p_orgn_id NUMBER) IS
2369: SELECT secondary_inventory_name
2370: FROM mtl_secondary_inventories
2371: WHERE organization_id = p_orgn_id
2372: AND secondary_inventory_name NOT IN
2373: (SELECT secondary_inventory_name
2374: FROM csp_sec_inventories