APPS.AHL_SB_RULES_PVT dependencies on AHL_SB_RULE_ITEMS_S

Line 146: FROM AHL_SB_RULE_ITEMS SBI,

142: CURSOR validate_sb_rule_csr (c_uc_header_id NUMBER,
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

Line 418: FROM AHL_SB_RULE_ITEMS SBI,

414: -- cursor to validate the given SB rule against the given instance
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

Line 689: FROM AHL_SB_RULE_ITEMS SBI,

685: CURSOR validate_sb_rule_csr (c_rule_id NUMBER,
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

Line 936: l_rule_association_id := AHL_SB_RULE_ITEMS_S.NEXTVAL;

932:
933: -- insert the rule's items
934: FOR l_get_rule_items_det_csr_rec IN get_rule_items_det_csr(l_get_rule_det_csr_rec.rule_id) LOOP
935: -- get the next value from the sequence
936: l_rule_association_id := AHL_SB_RULE_ITEMS_S.NEXTVAL;
937:
938: -- insert the item
939: INSERT INTO AHL_SB_RULE_ITEMS(
940: rule_association_id, object_version_number,

Line 1424: AHL_SB_RULE_ITEMS SBI

1420: -- curosr to get the SB rules defined for the positions affected by fork
1421: CURSOR get_rule_id_for_fork_csr (c_src_item_group_id NUMBER) IS
1422: SELECT DISTINCT SBR.rule_id
1423: FROM AHL_SB_POSITION_RULES SBR,
1424: AHL_SB_RULE_ITEMS SBI
1425: WHERE SBR.rule_id = SBI.rule_id
1426: AND SBI.item_group_id = c_src_item_group_id
1427: AND EXISTS (SELECT 'X'
1428: FROM AHL_MC_RELATIONSHIPS MCR

Line 1710: FROM AHL_SB_RULE_ITEMS SBI,

1706: CURSOR validate_sb_rule_csr (c_uc_header_id NUMBER,
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