APPS.CSD_LOGISTICS_UTIL dependencies on MTL_SYSTEM_ITEMS_B

Line 164: FROM mtl_system_items_b m

160:
161: -- Validate given item id against following sql query.
162: SELECT m.inventory_item_id
163: INTO l_Inventory_Item_ID
164: FROM mtl_system_items_b m
165: WHERE inventory_item_Id = p_Inventory_Item_Id
166: AND m.enabled_flag = 'Y'
167: AND NVL(m.service_item_flag, 'N') = 'N'
168: AND m.serv_req_enabled_code = 'E'

Line 331: mtl_system_items_b b,

327:
328: SELECT a.serial_number, a.Instance_number
329: INTO x_serial_number, x_Instance_number
330: FROM csi_item_instances a,
331: mtl_system_items_b b,
332: csi_i_parties cip,
333: csi_install_parameters ip
334: WHERE TRUNC(SYSDATE) BETWEEN
335: TRUNC(NVL(a.active_start_date, SYSDATE)) AND

Line 566: FROM mtl_system_items_b

562: AND organization_id = Cs_Std.get_item_valdn_orgzn_id
563: AND UOM_Code = p_Unit_Of_Measure
564: AND uom_type =
565: (SELECT allowed_units_lookup_code
566: FROM mtl_system_items_b
567: WHERE organization_id = Cs_Std.get_item_valdn_orgzn_id
568: AND inventory_item_id = p_inventory_item_id);
569:
570: EXCEPTION