DBA Data[Home] [Help]

APPS.AHL_REPORT_UTILS_PVT dependencies on AHL_ITEM_ASSOCIATIONS_B

Line 452: FROM AHL_ITEM_ASSOCIATIONS_B ata,

448: l_get_count NUMBER;
449:
450: CURSOR c_get_count(c_instance_id NUMBER) IS
451: SELECT COUNT(distinct aig.name)
452: FROM AHL_ITEM_ASSOCIATIONS_B ata,
453: AHL_ITEM_GROUPS_B aig,
454: CSI_ITEM_INSTANCES inst
455: WHERE inst.instance_id = c_instance_id
456: AND ata.inventory_item_id = inst.inventory_item_id