DBA Data[Home] [Help]

APPS.CSP_REPAIR_ORDER_PKG dependencies on CSP_PLANNING_PARAMETERS

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