APPS.CSD_RECEIVE_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 52: FROM mtl_system_items_b itm

48: )
49: IS
50: SELECT itm.receiving_routing_id,
51: itm.location_control_code, itm.serial_number_control_code
52: FROM mtl_system_items_b itm
53: WHERE itm.inventory_item_id = p_item_id
54: AND itm.organization_id = p_org_id;
55:
56: --Curosr to get the receive Parameters.

Line 88: FROM mtl_system_items_b itm

84: 1, g_inspection_routing,
85: null
86: ),
87: itm.location_control_code, itm.serial_number_control_code
88: FROM mtl_system_items_b itm
89: WHERE itm.inventory_item_id = p_item_id
90: AND itm.organization_id = p_org_id;
91:
92: BEGIN

Line 237: -- return_inspection_Requirement in mtl_system_items_b

233: END IF;
234:
235: ELSE
236: --For regular RMA's logic is, fist at item level and then at org level
237: -- return_inspection_Requirement in mtl_system_items_b
238: -- is used for item attribute
239: OPEN cur_item_routing_rma (p_inv_org_id, p_inventory_item_id);
240:
241: FETCH cur_item_routing_rma

Line 823: FROM mtl_system_items

819: p_item_id NUMBER
820: )
821: IS
822: SELECT lot_control_code, serial_number_control_code
823: FROM mtl_system_items
824: WHERE organization_id = p_org_id AND inventory_item_id = p_item_id;
825:
826:
827: -- Cursor to get the unit of measure