APPS.AHL_UTIL_UC_PKG dependencies on AHL_ITEM_ASSOCIATIONS_B

Line 653: FROM ahl_mc_relationships reln, ahl_item_associations_b iasso

649: reln.quantity Posn_Qty,
650: reln.uom_code Posn_uom_code,
651: iasso.revision Itm_revision,
652: iasso.item_association_id
653: FROM ahl_mc_relationships reln, ahl_item_associations_b iasso
654: WHERE reln.item_group_id = iasso.item_group_id
655: AND reln.relationship_id = p_mc_relationship_id
656: AND iasso.inventory_item_id = p_Inventory_id
657: AND iasso.inventory_org_id = p_Organization_id

Line 674: FROM ahl_mc_relationships reln, ahl_item_associations_b iasso

670: reln.quantity Posn_Qty,
671: reln.uom_code Posn_uom_code,
672: iasso.revision Itm_revision,
673: iasso.item_association_id
674: FROM ahl_mc_relationships reln, ahl_item_associations_b iasso
675: WHERE reln.item_group_id = iasso.item_group_id
676: AND reln.relationship_id = p_mc_relationship_id
677: AND iasso.inventory_item_id = p_Inventory_id
678: AND (iasso.revision IS NULL OR iasso.revision = p_revision)

Line 1312: FROM ahl_item_associations_b

1308: CURSOR check_item_group_csr(c_item_group_id IN NUMBER,
1309: c_inventory_item_id IN NUMBER,
1310: c_inventory_org_id IN NUMBER ) IS
1311: SELECT item_group_id
1312: FROM ahl_item_associations_b
1313: WHERE item_group_id = c_item_group_id
1314: AND inventory_item_id = c_inventory_item_id
1315: AND inventory_org_id = c_inventory_org_id;
1316:

Line 2178: ahl_item_associations_b A

2174: A.revision item_revision,
2175: R.quantity position_quantity,
2176: R.uom_code position_uom_code
2177: FROM ahl_mc_relationships R,
2178: ahl_item_associations_b A
2179: WHERE R.item_group_id = A.item_group_id
2180: AND R.relationship_id = c_mc_relationship_id
2181: AND A.inventory_item_id = c_inventory_item_id
2182: AND A.inventory_org_id = c_organization_id

Line 2626: FROM AHL_ITEM_ASSOCIATIONS_B

2622: CURSOR c_check_item_group_csr(c_item_group_id NUMBER,
2623: c_inventory_item_id NUMBER,
2624: c_inventory_org_id NUMBER ) IS
2625: SELECT item_group_id
2626: FROM AHL_ITEM_ASSOCIATIONS_B
2627: WHERE item_group_id = c_item_group_id AND
2628: inventory_item_id = c_inventory_item_id AND
2629: inventory_org_id = c_inventory_org_id;
2630:

Line 2910: SELECT 1 from ahl_item_associations_b

2906: FROM ahl_mc_relationships reln
2907: WHERE relationship_id = TO_NUMBER(c_pos_ref);
2908:
2909: CURSOR item_group_has_item_csr(c_item_group_id IN NUMBER) IS
2910: SELECT 1 from ahl_item_associations_b
2911: WHERE item_group_id = c_item_group_id
2912: AND inventory_item_id = p_inventory_item_id
2913: AND ((revision IS NULL) OR (revision = p_item_revision))
2914: AND interchange_type_code IN ('1-WAY INTERCHANGEABLE', '2-WAY INTERCHANGEABLE');