APPS.AHL_SB_RULES_PVT dependencies on AHL_ITEM_ASSOCIATIONS_B

Line 147: AHL_ITEM_ASSOCIATIONS_B IAB,

143: c_rule_id NUMBER,
144: c_relationship_id NUMBER) IS
145: SELECT 'X'
146: FROM AHL_SB_RULE_ITEMS SBI,
147: AHL_ITEM_ASSOCIATIONS_B IAB,
148: CSI_ITEM_INSTANCES CSI,
149: CSI_II_RELATIONSHIPS CSR
150: WHERE SBI.rule_id = c_rule_id
151: AND IAB.item_association_id = SBI.item_association_id

Line 419: AHL_ITEM_ASSOCIATIONS_B IAB,

415: CURSOR validate_sb_rule_csr (c_rule_id NUMBER,
416: c_instance_id NUMBER) IS
417: SELECT 'X'
418: FROM AHL_SB_RULE_ITEMS SBI,
419: AHL_ITEM_ASSOCIATIONS_B IAB,
420: CSI_ITEM_INSTANCES CSI
421: WHERE SBI.rule_id = c_rule_id
422: AND IAB.item_association_id = SBI.item_association_id
423: AND CSI.inventory_item_id = IAB.inventory_item_id

Line 690: AHL_ITEM_ASSOCIATIONS_B IAB,

686: c_inv_item_id NUMBER,
687: c_inv_org_id NUMBER) IS
688: SELECT 'X'
689: FROM AHL_SB_RULE_ITEMS SBI,
690: AHL_ITEM_ASSOCIATIONS_B IAB,
691: MTL_SYSTEM_ITEMS_B MTL
692: WHERE SBI.rule_id = c_rule_id
693: AND IAB.item_association_id = SBI.item_association_id
694: AND MTL.inventory_item_id = IAB.inventory_item_id

Line 1444: FROM AHL_ITEM_ASSOCIATIONS_B

1440: -- cursor to get the item associations' details for the given item group
1441: CURSOR get_item_asso_det_csr (c_item_group_id NUMBER) IS
1442: SELECT item_association_id,
1443: TO_CHAR(inventory_item_id)||'-'||revision||'-'||TO_CHAR(inventory_org_id) item_pattern
1444: FROM AHL_ITEM_ASSOCIATIONS_B
1445: WHERE item_group_id = c_item_group_id;
1446:
1447: -- cursor to check if the given SB rule is fit to delete, i.e. it has no items
1448: CURSOR chk_rule_del_OK_csr (c_rule_id NUMBER) IS

Line 1711: AHL_ITEM_ASSOCIATIONS_B IAB,

1707: c_rule_id NUMBER,
1708: c_relationship_id NUMBER) IS
1709: SELECT 'X'
1710: FROM AHL_SB_RULE_ITEMS SBI,
1711: AHL_ITEM_ASSOCIATIONS_B IAB,
1712: CSI_ITEM_INSTANCES CSI,
1713: CSI_II_RELATIONSHIPS CSR
1714: WHERE SBI.rule_id = c_rule_id
1715: AND IAB.item_association_id = SBI.item_association_id