APPS.AMS_DELIVERABLE_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 1321: FROM mtl_system_items_b_kfv

1317: -- SQLID : 11753349 Fix by musman
1318: -- commented out cursor which are not being used
1319: CURSOR c_inv_item_id(p_inv_item_num IN VARCHAR2) IS
1320: SELECT distinct(inventory_item_id)
1321: FROM mtl_system_items_b_kfv
1322: WHERE segment1 = p_inv_item_num;
1323:
1324: CURSOR c_pricelist_header_id IS
1325: SELECT distinct(pricelist_header_id)

Line 4813: FROM mtl_system_items_b

4809: ,costing_enabled_flag
4810: ,customer_order_flag
4811: ,customer_order_enabled_flag
4812: ,shippable_item_flag
4813: FROM mtl_system_items_b
4814: WHERE inventory_item_id = inv_id
4815: AND organization_id = org_id;
4816:
4817: l_flag_rec get_flag%ROWTYPE;