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

Line 93: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp

89:
90: CURSOR C_supplier (p_organization_id NUMBER,l_supplied_item_id NUMBER)
91: is select misl.source_type, misl.source_organization_id, misl.vendor_id
92: into l_source_type, l_repair_organization_id, l_repair_supplier_id
93: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp
94: where cpp.organization_id = p_organization_id
95: and misl.organization_id = cpp.organization_id
96: and misl.assignment_set_id =cpp.repair_assignment_set_id
97: and inventory_item_id = l_supplied_item_id --l_line_tbl(I).supplied_item_id

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

95: and misl.organization_id = cpp.organization_id
96: and misl.assignment_set_id =cpp.repair_assignment_set_id
97: and inventory_item_id = l_supplied_item_id --l_line_tbl(I).supplied_item_id
98: and SOURCE_TYPE in (1,3)
99: and sourcing_level = (select min(sourcing_level) from MRP_ITEM_SOURCING_LEVELS_V
100: where organization_id = p_organization_id
101: and assignment_set_id = cpp.repair_assignment_set_id
102: and inventory_item_id = l_supplied_item_id --l_line_tbl(I).supplied_item_id
103: and sourcing_level not in (2,9))

Line 188: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp

184: /*
185: begin
186: select misl.source_type, misl.source_organization_id, misl.vendor_id
187: into l_source_type, l_repair_organization_id, l_repair_supplier_id
188: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp
189: where cpp.organization_id = p_organization_id
190: and misl.organization_id = cpp.organization_id
191: and misl.assignment_set_id =cpp.repair_assignment_set_id
192: and inventory_item_id = l_line_tbl(I).supplied_item_id

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

190: and misl.organization_id = cpp.organization_id
191: and misl.assignment_set_id =cpp.repair_assignment_set_id
192: and inventory_item_id = l_line_tbl(I).supplied_item_id
193: and SOURCE_TYPE in (1,3)
194: and sourcing_level = (select min(sourcing_level) from MRP_ITEM_SOURCING_LEVELS_V
195: where organization_id = p_organization_id
196: and assignment_set_id = cpp.repair_assignment_set_id
197: and inventory_item_id = l_line_tbl(I).supplied_item_id
198: and sourcing_level not in (2,9))