APPS.AHL_ENIGMA_IPC_PROCS_PVT dependencies on AHL_ITEM_COMPOSITIONS

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 1335: -- update the new field SOURCED_FROM_ENIGMA_FLAG in the table AHL_ITEM_COMPOSITIONS

1331: END IF;
1332: RAISE FND_API.G_EXC_ERROR;
1333: END IF;
1334:
1335: -- update the new field SOURCED_FROM_ENIGMA_FLAG in the table AHL_ITEM_COMPOSITIONS
1336: UPDATE ahl_item_compositions
1337: SET sourced_from_enigma_flag = 'Y'
1338: WHERE item_composition_id = l_ic_header_rec.item_composition_id;
1339:

Line 1336: UPDATE ahl_item_compositions

1332: RAISE FND_API.G_EXC_ERROR;
1333: END IF;
1334:
1335: -- update the new field SOURCED_FROM_ENIGMA_FLAG in the table AHL_ITEM_COMPOSITIONS
1336: UPDATE ahl_item_compositions
1337: SET sourced_from_enigma_flag = 'Y'
1338: WHERE item_composition_id = l_ic_header_rec.item_composition_id;
1339:
1340: ELSIF (l_ic_header_rec.operation_flag = 'M') THEN