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.CSP_PLANNER_NOTIFICATIONS dependencies on MRP_ITEM_SOURCING_LEVELS_V

Line 1943: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp

1939: l_atr NUMBER;
1940:
1941: CURSOR excess_sources_cur IS
1942: select misl.source_organization_id
1943: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp
1944: where cpp.organization_id = p_organization_id
1945: and misl.organization_id = cpp.organization_id
1946: and misl.assignment_set_id =cpp.usable_assignment_set_id
1947: and inventory_item_id = p_item_rec.inventory_item_id

Line 1949: and sourcing_level = (select min(sourcing_level) from MRP_ITEM_SOURCING_LEVELS_V

1945: and misl.organization_id = cpp.organization_id
1946: and misl.assignment_set_id =cpp.usable_assignment_set_id
1947: and inventory_item_id = p_item_rec.inventory_item_id
1948: and SOURCE_TYPE = 1
1949: and sourcing_level = (select min(sourcing_level) from MRP_ITEM_SOURCING_LEVELS_V
1950: where organization_id = p_organization_id
1951: and assignment_set_id = cpp.usable_assignment_set_id
1952: and inventory_item_id = p_item_rec.inventory_item_id
1953: and sourcing_level not in (2,9));

Line 2341: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp

2337: ) IS
2338:
2339: CURSOR repair_sources_cur IS
2340: select misl.source_organization_id
2341: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp
2342: where cpp.organization_id = p_organization_id
2343: and misl.organization_id = cpp.organization_id
2344: and misl.assignment_set_id =cpp.defective_assignment_set_id
2345: and inventory_item_id = p_inventory_item_id

Line 2347: and sourcing_level = (select min(sourcing_level) from MRP_ITEM_SOURCING_LEVELS_V

2343: and misl.organization_id = cpp.organization_id
2344: and misl.assignment_set_id =cpp.defective_assignment_set_id
2345: and inventory_item_id = p_inventory_item_id
2346: and SOURCE_TYPE = 1
2347: and sourcing_level = (select min(sourcing_level) from MRP_ITEM_SOURCING_LEVELS_V
2348: where organization_id = p_organization_id
2349: and assignment_set_id = cpp.defective_assignment_set_id
2350: and inventory_item_id = p_inventory_item_id
2351: and sourcing_level not in (2,9));

Line 2355: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp

2351: and sourcing_level not in (2,9));
2352:
2353: CURSOR repair_suppliers_cur IS
2354: select misl.source_type, misl.source_organization_id
2355: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp
2356: where cpp.organization_id = p_organization_id
2357: and misl.organization_id = cpp.organization_id
2358: and misl.assignment_set_id =cpp.repair_assignment_set_id
2359: and inventory_item_id = p_inventory_item_id

Line 2361: and sourcing_level = (select min(sourcing_level) from MRP_ITEM_SOURCING_LEVELS_V

2357: and misl.organization_id = cpp.organization_id
2358: and misl.assignment_set_id =cpp.repair_assignment_set_id
2359: and inventory_item_id = p_inventory_item_id
2360: and SOURCE_TYPE in (1,3)
2361: and sourcing_level = (select min(sourcing_level) from MRP_ITEM_SOURCING_LEVELS_V
2362: where organization_id = p_organization_id
2363: and assignment_set_id = cpp.repair_assignment_set_id
2364: and inventory_item_id = p_inventory_item_id
2365: and sourcing_level not in (2,9))