APPS.AHL_MM_MTL_MGT_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 4442: l_item mtl_system_items_kfv.concatenated_segments%TYPE;

4438: l_trans_count NUMBER;
4439: l_error_msg VARCHAR2(240);
4440: l_error_code VARCHAR2(240);
4441:
4442: l_item mtl_system_items_kfv.concatenated_segments%TYPE;
4443: l_serial MTL_SERIAL_NUMBERS_INTERFACE.FM_SERIAL_NUMBER%TYPE;
4444: l_shipping_network_code MTL_SHIPPING_NETWORK_VIEW.intransit_type%TYPE;
4445:
4446: -- Record Type variables

Line 4458: mtl_system_items_kfv kfv,

4454: intf.ERROR_CODE,
4455: kfv.concatenated_segments,
4456: sni.FM_SERIAL_NUMBER
4457: FROM MTL_TRANSACTIONS_INTERFACE INTF,
4458: mtl_system_items_kfv kfv,
4459: MTL_SERIAL_NUMBERS_INTERFACE sni
4460: WHERE intf.TRANSACTION_INTERFACE_ID = p_txn_Id
4461: AND intf.inventory_item_id = kfv.inventory_item_id
4462: AND intf.organization_id = kfv.organization_id

Line 5155: FROM MTL_SYSTEM_ITEMS_KFV

5151: REVISION_QTY_CONTROL_CODE,
5152: LOCATION_CONTROL_CODE,
5153: primary_uom_code,
5154: concatenated_segments
5155: FROM MTL_SYSTEM_ITEMS_KFV
5156: WHERE ORGANIZATION_ID = p_org_id
5157: AND INVENTORY_ITEM_ID = p_item
5158: AND ENABLED_FLAG = 'Y'
5159: AND ((START_DATE_ACTIVE IS NULL)

Line 5172: FROM MTL_SYSTEM_ITEMS_KFV

5168: REVISION_QTY_CONTROL_CODE,
5169: LOCATION_CONTROL_CODE,
5170: primary_uom_code,
5171: concatenated_segments
5172: FROM MTL_SYSTEM_ITEMS_KFV
5173: WHERE ORGANIZATION_ID = p_org_id
5174: AND INVENTORY_ITEM_ID = p_item
5175: AND ENABLED_FLAG = 'Y'
5176: AND ((START_DATE_ACTIVE IS NULL)

Line 5224: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;

5220: l_location_control_src NUMBER;
5221: l_location_control_dest NUMBER;
5222: l_temp_number NUMBER;
5223: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;
5224: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
5225: l_src_organization_name Org_Organization_definitions.organization_name%TYPE;
5226: l_dest_organization_name Org_Organization_definitions.organization_name%TYPE;
5227: BEGIN
5228: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5238: FROM mtl_system_items_kfv

5234: -- get the item name instead of id for error message purpose
5235: BEGIN
5236: SELECT concatenated_segments
5237: INTO l_concatenated_segments
5238: FROM mtl_system_items_kfv
5239: WHERE inventory_item_id = p_x_mtltfr_rec.Inventory_Item_Id
5240: AND organization_id = p_x_mtltfr_rec.dest_org_id;
5241: EXCEPTION
5242: WHEN OTHERS

Line 6294: FROM mtl_system_items_kfv

6290: CURSOR item_details_cur(c_inv_item_id NUMBER, c_org_id NUMBER)
6291: IS
6292: SELECT primary_uom_code,
6293: concatenated_segments
6294: FROM mtl_system_items_kfv
6295: WHERE inventory_item_id = c_inv_item_id
6296: AND organization_id = c_org_id;
6297: CURSOR mfg_err_msg_cur(C_LOOKUP_CODE NUMBER)
6298: IS