APPS.CSD_LOGISTICS_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 145: /* in the mtl system items table */

141: END DEBUG;
142: /*---------------------------------------------------------------------------*/
143: /* procedure name: Validate_InventoryItemID */
144: /* description : Helper routine that Validates item for a given item ID */
145: /* in the mtl system items table */
146: /* Parameters Required: */
147: /* p_Inventory_Item_Id IN Item identifier */
148: /* x_return_status OUT Standard API paramater */
149: /* x_msg_count OUT Standard API paramater */

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

Line 998: FROM mtl_system_items_kfv

994: BEGIN
995:
996: SELECT Concatenated_Segments
997: INTO x_Concatenated_Segments
998: FROM mtl_system_items_kfv
999: WHERE Inventory_Item_Id = p_Inventory_item_Id
1000: AND Organization_Id = Fnd_Profile.value('CS_INV_VALIDATION_ORG');
1001:
1002: --SU:02/24: Following statement can be commented.

Line 2020: FROM mtl_system_items

2016: x_ItemAttributes.Revision_Code,
2017: x_ItemAttributes.Lot_Code,
2018: x_ItemAttributes.IB_Flag,
2019: x_itemAttributes.reservable_type
2020: FROM mtl_system_items
2021: WHERE inventory_item_id = p_Inventory_Item_Id
2022: AND organization_id = p_Inv_Org_id;
2023:
2024: EXCEPTION

Line 2727: FROM mtl_system_items

2723:
2724: BEGIN
2725: SELECT revision_qty_control_code
2726: INTO l_rev_ctl_code
2727: FROM mtl_system_items
2728: WHERE organization_id =
2729: Cs_Std.get_item_valdn_orgzn_id
2730: AND inventory_item_id =
2731: p_product_txn_rec.inventory_item_id;