APPS.AHL_CMP_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 191: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;

187:
188: l_error_msg varchar2(240);
189: l_error_code varchar2(240);
190: l_error BOOLEAN;
191: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
192:
193:
194: --Query to get the error messages
195: CURSOR Txn_Error_Cur(p_txn_Id NUMBER) IS

Line 197: FROM MTL_TRANSACTIONS_INTERFACE INTF, mtl_system_items_kfv kfv

193:
194: --Query to get the error messages
195: CURSOR Txn_Error_Cur(p_txn_Id NUMBER) IS
196: SELECT intf.ERROR_EXPLANATION ,intf.ERROR_CODE, kfv.concatenated_segments
197: FROM MTL_TRANSACTIONS_INTERFACE INTF, mtl_system_items_kfv kfv
198: WHERE TRANSACTION_INTERFACE_ID = p_txn_Id
199: AND intf.inventory_item_id = kfv.inventory_item_id
200: AND intf.organization_id = kfv.organization_id ;
201:

Line 429: FROM MTL_SYSTEM_ITEMS_KFV

425: -- Item id validation and selecting serial control code,lot control code values
426: CURSOR AHL_ITEM_ID_CUR (p_org_id NUMBER, p_item NUMBER) IS
427: SELECT SERIAL_NUMBER_CONTROL_CODE, LOT_CONTROL_CODE, REVISION_QTY_CONTROL_CODE,
428: LOCATION_CONTROL_CODE,primary_uom_code, concatenated_segments
429: FROM MTL_SYSTEM_ITEMS_KFV
430: WHERE ORGANIZATION_ID = p_org_id
431: AND INVENTORY_ITEM_ID = p_item
432: AND ENABLED_FLAG = 'Y'
433: AND ((START_DATE_ACTIVE IS NULL) OR (START_DATE_ACTIVE <= SYSDATE))

Line 492: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;

488: l_txn_type VARCHAR2(80);
489: l_curr_subinventory_code mtl_serial_numbers.current_subinventory_code%TYPE;
490: l_curr_locator_id NUMBER;
491: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;
492: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
493: l_junk VARCHAR2(1);
494:
495:
496: BEGIN

Line 1241: FROM CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL

1237: CSI.lot_number,
1238: CSI.quantity,
1239: CSI.unit_of_measure,
1240: MTL.concatenated_segments
1241: FROM CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL
1242: WHERE CSI.inv_master_organization_id = c_item_mstr_org_id
1243: AND CSI.inv_organization_id = c_item_inv_org_id
1244: AND CSI.inventory_item_id = c_inv_item_id
1245: AND CSI.instance_id = c_instance_id

Line 2318: FROM CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL

2314: MTL.concatenated_segments,
2315: CSI.inv_master_organization_id,
2316: CSI.inv_organization_id,
2317: CSI.inventory_item_id
2318: FROM CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL
2319: WHERE CSI.instance_id = p_instance_id_csr
2320: AND MTL.inventory_item_id = CSI.inventory_item_id
2321: AND MTL.organization_id = CSI.inv_master_organization_id
2322: AND TRUNC(NVL(CSI.active_start_date, SYSDATE)) <= TRUNC(SYSDATE)

Line 3294: FROM MTL_SYSTEM_ITEMS_KFV

3290:
3291: CURSOR Get_Srl_Ctrl_Code(p_org_id NUMBER, p_item_id NUMBER)
3292: IS
3293: SELECT serial_number_control_code
3294: FROM MTL_SYSTEM_ITEMS_KFV
3295: WHERE organization_id = p_org_id
3296: AND inventory_item_id = p_item_id ;
3297:
3298: l_return_status VARCHAR2(10);