DBA Data[Home] [Help]

APPS.CSP_PARTS_ORDER dependencies on MTL_PLANNERS

Line 4566: Select employee_id into l_planner_employee_id From MTL_PLANNERS

4562: l_SUGGESTED_VENDOR_NAME := l_header_rec.SUGGESTED_VENDOR_NAME;
4563: l_source_organization_id := l_line_tbl(i).source_organization_id;
4564: l_autosource_flag := 'N';
4565: Begin
4566: Select employee_id into l_planner_employee_id From MTL_PLANNERS
4567: Where Organization_id = l_header_rec.dest_organization_id
4568: and Planner_code = ( Select Planner_code from mtl_system_items_b
4569: where inventory_item_id = l_line_tbl(i).inventory_item_id and organization_id =
4570: l_header_rec.dest_organization_id )