DBA Data[Home] [Help]

APPS.AHL_REPORT_UTILS_PVT dependencies on AHL_ITEM_GROUPS_B

Line 453: AHL_ITEM_GROUPS_B aig,

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
457: AND ata.inventory_org_id = inst.inv_master_organization_id --AJPRASAN:: Added this where clause