APPS.AHL_ENIGMA_IPC_PROCS_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 164: FROM mtl_system_items_kfv

160: AND TRUNC(NVL(end_date_active, SYSDATE - 1)) < TRUNC(SYSDATE);
161:
162: CURSOR get_item_id_csr (p_item_number VARCHAR2, p_org_id NUMBER) IS
163: SELECT inventory_item_id
164: FROM mtl_system_items_kfv
165: WHERE concatenated_segments = NVL(p_item_number, '-')
166: AND organization_id = p_org_id;
167:
168: CURSOR chk_interchg_type_code_csr (p_interchg_type_code VARCHAR2) IS

Line 1054: FROM ahl_item_compositions ahl, mtl_system_items_kfv mtl

1050:
1051: CURSOR get_ic_id_csr (p_item_name VARCHAR2, p_org_id NUMBER) IS
1052: SELECT ahl.item_composition_id,
1053: ahl.object_version_number
1054: FROM ahl_item_compositions ahl, mtl_system_items_kfv mtl
1055: WHERE mtl.concatenated_segments = NVL(p_item_name, '-')
1056: AND mtl.organization_id = p_org_id
1057: AND mtl.inventory_item_id = ahl.inventory_item_id
1058: AND TRUNC(NVL(ahl.effective_end_date, SYSDATE + 1)) > TRUNC(SYSDATE)

Line 1063: FROM mtl_system_items_kfv

1059: AND NVL(ahl.sourced_from_enigma_flag, 'N') = 'Y';
1060:
1061: CURSOR get_item_id_csr (p_item_number VARCHAR2, p_org_id NUMBER) IS
1062: SELECT inventory_item_id
1063: FROM mtl_system_items_kfv
1064: WHERE concatenated_segments = NVL(p_item_number, '-')
1065: AND organization_id = p_org_id;
1066:
1067: CURSOR get_ic_det_id_csr (p_ic_id NUMBER, p_item_id NUMBER, p_org_id NUMBER) IS