APPS.AHL_UTIL_UC_PKG dependencies on AHL_ITEM_ASSOCIATIONS_B

Line 658: FROM ahl_mc_relationships reln, ahl_item_associations_b iasso

654: reln.quantity Posn_Qty,
655: reln.uom_code Posn_uom_code,
656: iasso.revision Itm_revision,
657: iasso.item_association_id
658: FROM ahl_mc_relationships reln, ahl_item_associations_b iasso
659: WHERE reln.item_group_id = iasso.item_group_id
660: AND reln.relationship_id = p_mc_relationship_id
661: AND iasso.inventory_item_id = p_Inventory_id
662: AND iasso.inventory_org_id = p_Organization_id

Line 679: FROM ahl_mc_relationships reln, ahl_item_associations_b iasso

675: reln.quantity Posn_Qty,
676: reln.uom_code Posn_uom_code,
677: iasso.revision Itm_revision,
678: iasso.item_association_id
679: FROM ahl_mc_relationships reln, ahl_item_associations_b iasso
680: WHERE reln.item_group_id = iasso.item_group_id
681: AND reln.relationship_id = p_mc_relationship_id
682: AND iasso.inventory_item_id = p_Inventory_id
683: AND (iasso.revision IS NULL OR iasso.revision = p_revision)

Line 1317: FROM ahl_item_associations_b

1313: CURSOR check_item_group_csr(c_item_group_id IN NUMBER,
1314: c_inventory_item_id IN NUMBER,
1315: c_inventory_org_id IN NUMBER ) IS
1316: SELECT item_group_id
1317: FROM ahl_item_associations_b
1318: WHERE item_group_id = c_item_group_id
1319: AND inventory_item_id = c_inventory_item_id
1320: AND inventory_org_id = c_inventory_org_id;
1321:

Line 2183: ahl_item_associations_b A

2179: A.revision item_revision,
2180: R.quantity position_quantity,
2181: R.uom_code position_uom_code
2182: FROM ahl_mc_relationships R,
2183: ahl_item_associations_b A
2184: WHERE R.item_group_id = A.item_group_id
2185: AND R.relationship_id = c_mc_relationship_id
2186: AND A.inventory_item_id = c_inventory_item_id
2187: AND A.inventory_org_id = c_organization_id

Line 2631: FROM AHL_ITEM_ASSOCIATIONS_B

2627: CURSOR c_check_item_group_csr(c_item_group_id NUMBER,
2628: c_inventory_item_id NUMBER,
2629: c_inventory_org_id NUMBER ) IS
2630: SELECT item_group_id
2631: FROM AHL_ITEM_ASSOCIATIONS_B
2632: WHERE item_group_id = c_item_group_id AND
2633: inventory_item_id = c_inventory_item_id AND
2634: inventory_org_id = c_inventory_org_id;
2635:

Line 2915: SELECT 1 from ahl_item_associations_b

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