APPS.CSP_PLANNER_NOTIFICATIONS dependencies on CSP_SEC_INVENTORIES

Line 1959: FROM csp_sec_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
1959: FROM csp_sec_inventories
1960: WHERE condition_type = 'B'
1961: AND organization_id = p_orgn_id);
1962: */
1963:

Line 1966: FROM csp_sec_inventories

1962: */
1963:
1964: CURSOR d_wrhs_subinv_cur(p_orgn_id NUMBER) IS
1965: SELECT secondary_inventory_name
1966: FROM csp_sec_inventories
1967: WHERE organization_id = p_orgn_id
1968: AND condition_type = 'G';
1969:
1970: CURSOR employee_id_cur IS

Line 2371: FROM csp_sec_inventories

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
2372: WHERE condition_type = 'G'
2373: AND organization_id = p_orgn_id);
2374:
2375: CURSOR u_wrhs_subinv_cur(p_orgn_id NUMBER) IS

Line 2377: FROM csp_sec_inventories

2373: AND organization_id = p_orgn_id);
2374:
2375: CURSOR u_wrhs_subinv_cur(p_orgn_id NUMBER) IS
2376: SELECT secondary_inventory_name
2377: FROM csp_sec_inventories
2378: WHERE organization_id = p_orgn_id
2379: AND condition_type = 'B';
2380:
2381: l_onhand_source NUMBER := 3;