APPS.CSP_PLANNER_NOTIFICATIONS dependencies on CSP_SEC_INVENTORIES

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

Line 1969: FROM csp_sec_inventories

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

Line 2374: FROM csp_sec_inventories

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

Line 2380: FROM csp_sec_inventories

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