APPS.CSP_PARTS_ORDER dependencies on MTL_SYSTEM_ITEMS_B

Line 1442: FROM mtl_system_items_b

1438: -- it is assumed that the calling procedure will always pass the Item ID
1439: -- so that Item Description can be derived.
1440: CURSOR item_Desc_cur(p_item_id NUMBER, p_orgn_id NUMBER) IS
1441: SELECT description
1442: FROM mtl_system_items_b
1443: WHERE inventory_item_id = p_item_id
1444: AND organization_id = p_orgn_id;
1445: -- Bug 14494663 - Not required as in case of special ship address as we cannot create address
1446: /* CURSOR rs_loc_exists_cur(p_inv_loc_id NUMBER, p_resource_id NUMBER, p_resource_type VARCHAR2) IS

Line 4568: and Planner_code = ( Select Planner_code from mtl_system_items_b

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 )
4571: and nvl(DISABLE_DATE,SYSDATE+1) > SYSDATE;
4572: Exception