eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_SB_RULES_PVT dependencies on AHL_SB_RULE_ITEMS

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 834: FROM AHL_SB_RULE_ITEMS

830:
831: -- curosr to get the SB rule items' details for a given rule id
832: CURSOR get_rule_items_det_csr (c_rule_id NUMBER) IS
833: SELECT *
834: FROM AHL_SB_RULE_ITEMS
835: WHERE rule_id = c_rule_id;
836:
837: --
838: l_api_version CONSTANT NUMBER := 1.0;

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 939: INSERT INTO AHL_SB_RULE_ITEMS(

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,
941: last_update_date, last_updated_by, creation_date, created_by, last_update_login,
942: rule_id, item_group_id,
943: item_association_id, sub_config_item)

Line 1169: DELETE FROM AHL_SB_RULE_ITEMS WHERE rule_id = l_get_rule_id_csr_rec.rule_id;

1165: FND_LOG.string(l_log_statement, l_full_name, 'erring SB MC found = '||l_sb_mc_hdr_id_tbl(i));
1166: END IF;
1167: FOR l_get_rule_id_csr_rec IN get_rule_id_csr(l_sb_mc_hdr_id_tbl(i), p_mr_header_id) LOOP
1168: -- delete the SB rule items
1169: DELETE FROM AHL_SB_RULE_ITEMS WHERE rule_id = l_get_rule_id_csr_rec.rule_id;
1170:
1171: -- delete the SB rule itself
1172: DELETE FROM AHL_SB_POSITION_RULES WHERE rule_id = l_get_rule_id_csr_rec.rule_id;
1173:

Line 1328: DELETE FROM AHL_SB_RULE_ITEMS WHERE rule_id = l_rule_id_tbl(i);

1324:
1325: IF (l_rule_id_tbl.COUNT > 0) THEN
1326: FOR i IN l_rule_id_tbl.FIRST..l_rule_id_tbl.LAST LOOP
1327: -- 1) Delete the SB rule items
1328: DELETE FROM AHL_SB_RULE_ITEMS WHERE rule_id = l_rule_id_tbl(i);
1329:
1330: -- 2) Delete the SB rule itself
1331: DELETE FROM AHL_SB_POSITION_RULES WHERE rule_id = l_rule_id_tbl(i);
1332: END LOOP; -- LOOP for l_rule_id_tbl

Line 1411: FROM AHL_SB_RULE_ITEMS

1407:
1408: -- cursor to check whether SB rule update is required
1409: CURSOR chk_rule_upd_required (c_src_item_group_id NUMBER) IS
1410: SELECT 'X'
1411: FROM AHL_SB_RULE_ITEMS
1412: WHERE item_group_id = c_src_item_group_id;
1413:
1414: -- cursor to check the given item group id
1415: CURSOR chk_item_group_id_csr (c_item_group_id NUMBER) IS

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 1450: FROM AHL_SB_RULE_ITEMS

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
1449: SELECT 'X'
1450: FROM AHL_SB_RULE_ITEMS
1451: WHERE rule_id = c_rule_id;
1452:
1453: -- cursor to check if SB rule item exists for a given item association
1454: CURSOR chk_rule_exists_csr (c_item_asso_id NUMBER) IS

Line 1456: FROM AHL_SB_RULE_ITEMS

1452:
1453: -- cursor to check if SB rule item exists for a given item association
1454: CURSOR chk_rule_exists_csr (c_item_asso_id NUMBER) IS
1455: SELECT 'X'
1456: FROM AHL_SB_RULE_ITEMS
1457: WHERE item_association_id = c_item_asso_id;
1458:
1459: --
1460: l_api_name CONSTANT VARCHAR2(30) := 'Update_Rules_For_IG';

Line 1545: DELETE FROM AHL_SB_RULE_ITEMS

1541:
1542: IF (l_rule_id_for_fork_tbl.COUNT > 0) THEN
1543: FOR i IN l_rule_id_for_fork_tbl.FIRST..l_rule_id_for_fork_tbl.LAST LOOP
1544: -- 2) For these rules, delete the items coming from the source item group
1545: DELETE FROM AHL_SB_RULE_ITEMS
1546: WHERE rule_id = l_rule_id_for_fork_tbl(i)
1547: AND item_group_id = p_src_item_group_id;
1548:
1549: IF (l_log_statement >= l_log_current_level) THEN

Line 1597: DELETE FROM AHL_SB_RULE_ITEMS WHERE item_association_id = l_src_item_asso_id_tbl(i);

1593: CLOSE chk_rule_exists_csr;
1594: IF (l_dummy IS NOT NULL) THEN
1595: IF (NOT l_item_pattern_tbl.EXISTS(l_src_item_pattern_tbl(i))) THEN
1596: -- delete the rule item
1597: DELETE FROM AHL_SB_RULE_ITEMS WHERE item_association_id = l_src_item_asso_id_tbl(i);
1598: l_action := 'deleted';
1599: ELSE
1600: -- update the rule item
1601: UPDATE AHL_SB_RULE_ITEMS

Line 1601: UPDATE AHL_SB_RULE_ITEMS

1597: DELETE FROM AHL_SB_RULE_ITEMS WHERE item_association_id = l_src_item_asso_id_tbl(i);
1598: l_action := 'deleted';
1599: ELSE
1600: -- update the rule item
1601: UPDATE AHL_SB_RULE_ITEMS
1602: SET item_association_id = l_item_asso_id_tbl(l_src_item_pattern_tbl(i))
1603: WHERE item_association_id = l_src_item_asso_id_tbl(i);
1604: l_action := 'updated';
1605: END IF; -- item pattern check

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