APPS.AHL_UMP_UF_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 452: FROM mtl_system_items_kfv

448: l_inventory_item_id NUMBER;
449:
450: CURSOR inventory_item_id_csr(p_inventory_item_name IN VARCHAR2) IS
451: SELECT inventory_item_id
452: FROM mtl_system_items_kfv
453: WHERE concatenated_segments = p_inventory_item_name;
454:
455:
456: CURSOR uf_header_id_pid_csr(p_inventory_item_id IN NUMBER) IS

Line 576: FROM mtl_system_items_kfv

572: l_unit_config_status_code ahl_unit_header_details_v.unit_config_status_code%TYPE;
573:
574: CURSOR part_check_csr(p_inventory_item_id IN NUMBER) IS
575: SELECT 'x'
576: FROM mtl_system_items_kfv
577: WHERE inventory_item_id = p_inventory_item_id;
578:
579: l_exists VARCHAR2(1);
580:

Line 848: --l_part_number mtl_system_items_kfv.concatenated_segments%TYPE;

844: l_inventory_item_id NUMBER;
845: l_csi_item_instance_id NUMBER;
846: l_use_unit_flag ahl_uf_headers.use_unit_flag%TYPE;
847:
848: --l_part_number mtl_system_items_kfv.concatenated_segments%TYPE;
849:
850: CURSOR part_check_csr(p_inventory_item_id IN NUMBER) IS
851: SELECT 'x'
852: FROM mtl_system_items_kfv

Line 852: FROM mtl_system_items_kfv

848: --l_part_number mtl_system_items_kfv.concatenated_segments%TYPE;
849:
850: CURSOR part_check_csr(p_inventory_item_id IN NUMBER) IS
851: SELECT 'x'
852: FROM mtl_system_items_kfv
853: WHERE inventory_item_id = p_inventory_item_id;
854:
855: l_exists VARCHAR2(1);
856:

Line 1964: CURSOR ahl_get_inv_item_id_csr(c_part_number IN mtl_system_items_kfv.concatenated_segments%TYPE) IS

1960: SELECT unit_config_header_id
1961: FROM ahl_unit_config_headers
1962: WHERE name = c_unit_name;
1963: --
1964: CURSOR ahl_get_inv_item_id_csr(c_part_number IN mtl_system_items_kfv.concatenated_segments%TYPE) IS
1965: SELECT inventory_item_id
1966: FROM mtl_system_items_kfv
1967: WHERE concatenated_segments = c_part_number;
1968: --

Line 1966: FROM mtl_system_items_kfv

1962: WHERE name = c_unit_name;
1963: --
1964: CURSOR ahl_get_inv_item_id_csr(c_part_number IN mtl_system_items_kfv.concatenated_segments%TYPE) IS
1965: SELECT inventory_item_id
1966: FROM mtl_system_items_kfv
1967: WHERE concatenated_segments = c_part_number;
1968: --
1969: CURSOR ahl_pc_id_from_assoc_csr(c_unit_config_header_id IN NUMBER,
1970: c_type IN VARCHAR2,