DBA Data[Home] [Help]

APPS.CSP_PLANNED_ORDERS dependencies on CSP_PLANNING_PARAMETERS

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 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