DBA Data[Home] [Help]

APPS.CSP_PLANNER_NOTIFICATIONS dependencies on MTL_SECONDARY_INVENTORIES

Line 1954: FROM mtl_secondary_inventories

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

Line 2367: FROM mtl_secondary_inventories

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