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_REPAIR_ORDER_PKG dependencies on MRP_ITEM_SOURCING_LEVELS_V

Line 37: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp

33: l_supplier_type VARCHAR2(240);
34:
35: cursor destination_organization is
36: select misl.organization_id
37: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp
38: where cpp.organization_type = 'W'
39: and misl.organization_id = cpp.organization_id
40: and misl.assignment_set_id =cpp.defective_assignment_set_id
41: and misl.source_organization_id = l_org_id

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

40: and misl.assignment_set_id =cpp.defective_assignment_set_id
41: and misl.source_organization_id = l_org_id
42: and misl.inventory_item_id = l_item_id
43: and SOURCE_TYPE in (1,3)
44: and sourcing_level = (select min(sourcing_level) from MRP_ITEM_SOURCING_LEVELS_V
45: where organization_id = cpp.organization_id
46: and assignment_set_id = cpp.defective_assignment_set_id
47: and inventory_item_id = misl.inventory_item_id
48: and sourcing_level not in (2,9))

Line 53: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp

49: order by misl.rank;
50:
51: CURSOR repair_suppliers_cur IS
52: select misl.source_type, misl.source_organization_id, misl.vendor_id
53: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp
54: where cpp.organization_id = l_dest_org_id
55: and misl.organization_id = cpp.organization_id
56: and misl.assignment_set_id =cpp.repair_assignment_set_id
57: and inventory_item_id = l_item_id

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

55: and misl.organization_id = cpp.organization_id
56: and misl.assignment_set_id =cpp.repair_assignment_set_id
57: and inventory_item_id = l_item_id
58: and SOURCE_TYPE in (1,3)
59: and sourcing_level = (select min(sourcing_level) from MRP_ITEM_SOURCING_LEVELS_V
60: where organization_id = l_dest_org_id
61: and assignment_set_id = cpp.repair_assignment_set_id
62: and inventory_item_id = l_item_id
63: and sourcing_level not in (2,9))