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_POSITION_RULES_S

Line 71: FROM AHL_SB_POSITION_RULES SB,

67: CURSOR get_appl_sb_rules_csr1 (c_uc_header_id NUMBER) IS
68: SELECT SB.rule_id,
69: SB.rule_name,
70: SB.relationship_id
71: FROM AHL_SB_POSITION_RULES SB,
72: AHL_UNIT_CONFIG_HEADERS UC
73: WHERE UC.unit_config_header_id = c_uc_header_id
74: AND SB.mc_header_id = UC.master_config_id
75: -- take only the rules which have MRs accomplished on the unit

Line 83: FROM AHL_SB_POSITION_RULES SB2

79: AND UE.csi_item_instance_id = UC.csi_item_instance_id -- SB MRs are effective on root node
80: AND UE.accomplished_date IS NOT NULL)
81: -- take only the MAX sequence rules for a position, among the accomplished MRs
82: AND SB.rule_sequence = (SELECT MAX(SB2.rule_sequence)
83: FROM AHL_SB_POSITION_RULES SB2
84: WHERE SB2.relationship_id = SB.relationship_id
85: AND EXISTS (SELECT 'X'
86: FROM AHL_UNIT_EFFECTIVITIES_B UE
87: WHERE UE.mr_header_id = SB2.mr_header_id

Line 99: FROM AHL_SB_POSITION_RULES SB,

95: c_visit_id NUMBER) IS
96: SELECT SB.rule_id,
97: SB.rule_name,
98: SB.relationship_id
99: FROM AHL_SB_POSITION_RULES SB,
100: AHL_UNIT_CONFIG_HEADERS UC
101: WHERE UC.unit_config_header_id = c_uc_header_id
102: AND SB.mc_header_id = UC.master_config_id
103: -- take only the rules which have MRs accomplished on the unit

Line 111: FROM AHL_SB_POSITION_RULES SB2

107: AND UE.csi_item_instance_id = UC.csi_item_instance_id -- SB MRs are effective on root node
108: AND UE.accomplished_date IS NOT NULL)
109: -- take only the MAX sequence rules for a position, among the accomplished MRs
110: AND SB.rule_sequence = (SELECT MAX(SB2.rule_sequence)
111: FROM AHL_SB_POSITION_RULES SB2
112: WHERE SB2.relationship_id = SB.relationship_id
113: AND EXISTS (SELECT 'X'
114: FROM AHL_UNIT_EFFECTIVITIES_B UE
115: WHERE UE.mr_header_id = SB2.mr_header_id

Line 124: FROM AHL_SB_POSITION_RULES SB,

120: UNION
121: SELECT SB.rule_id,
122: SB.rule_name,
123: SB.relationship_id
124: FROM AHL_SB_POSITION_RULES SB,
125: AHL_VISIT_TASKS_B VT,
126: AHL_UNIT_CONFIG_HEADERS UC
127: WHERE UC.unit_config_header_id = c_uc_header_id
128: AND SB.mc_header_id = UC.master_config_id

Line 135: FROM AHL_SB_POSITION_RULES SB2

131: AND VT.mr_id = SB.mr_header_id
132: AND VT.status_code NOT IN ('CANCELLED', 'DELETED')
133: -- take only the MAX sequence rules for a position
134: AND SB.rule_sequence = (SELECT MAX(SB2.rule_sequence)
135: FROM AHL_SB_POSITION_RULES SB2
136: WHERE SB2.relationship_id = SB.relationship_id
137: AND SB2.mr_header_id = SB.mr_header_id)
138: AND TRUNC(NVL(SB.active_start_date, SYSDATE)) <= TRUNC(SYSDATE)
139: AND TRUNC(NVL(SB.active_end_date, SYSDATE+1)) > TRUNC(SYSDATE);

Line 386: FROM AHL_SB_POSITION_RULES SB,

382: c_instance_id NUMBER) IS
383: SELECT SB.rule_id,
384: SB.rule_name,
385: SB.relationship_id
386: FROM AHL_SB_POSITION_RULES SB,
387: AHL_UNIT_CONFIG_HEADERS UC
388: WHERE UC.unit_config_header_id = c_uc_header_id
389: AND SB.mc_header_id = UC.master_config_id
390: -- take only the rules which have MRs accomplished on the unit

Line 398: FROM AHL_SB_POSITION_RULES SB2

394: AND UE.csi_item_instance_id = UC.csi_item_instance_id -- SB MRs are effective on root node
395: AND UE.accomplished_date IS NOT NULL)
396: -- take only the MAX sequence rules for a position, among the accomplished MRs
397: AND SB.rule_sequence = (SELECT MAX(SB2.rule_sequence)
398: FROM AHL_SB_POSITION_RULES SB2
399: WHERE SB2.relationship_id = SB.relationship_id
400: AND EXISTS (SELECT 'X'
401: FROM AHL_UNIT_EFFECTIVITIES_B UE
402: WHERE UE.mr_header_id = SB2.mr_header_id

Line 661: FROM AHL_SB_POSITION_RULES SB,

657: CURSOR get_appl_sb_rules_csr (c_uc_header_id NUMBER,
658: c_relationship_id NUMBER) IS
659: SELECT SB.rule_id,
660: SB.rule_name
661: FROM AHL_SB_POSITION_RULES SB,
662: AHL_UNIT_CONFIG_HEADERS UC
663: WHERE UC.unit_config_header_id = c_uc_header_id
664: AND SB.mc_header_id = UC.master_config_id
665: -- take only the rules which have MRs accomplished on the unit

Line 673: FROM AHL_SB_POSITION_RULES SB2

669: AND UE.csi_item_instance_id = UC.csi_item_instance_id -- SB MRs are effective on root node
670: AND UE.accomplished_date IS NOT NULL)
671: -- take only the MAX sequence rules for a position, among the accomplished MRs
672: AND SB.rule_sequence = (SELECT MAX(SB2.rule_sequence)
673: FROM AHL_SB_POSITION_RULES SB2
674: WHERE SB2.relationship_id = SB.relationship_id
675: AND EXISTS (SELECT 'X'
676: FROM AHL_UNIT_EFFECTIVITIES_B UE
677: WHERE UE.mr_header_id = SB2.mr_header_id

Line 917: l_rule_id := AHL_SB_POSITION_RULES_S.NEXTVAL;

913:
914: -- 2) copy the SB rules and their items
915: FOR l_get_rule_det_csr_rec IN get_rule_det_csr(p_src_mr_header_id) LOOP
916: -- get the next value from the sequence
917: l_rule_id := AHL_SB_POSITION_RULES_S.NEXTVAL;
918:
919: -- insert the rule
920: INSERT INTO AHL_SB_POSITION_RULES(
921: rule_id, object_version_number,

Line 1423: FROM AHL_SB_POSITION_RULES SBR,

1419:
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'

Line 1683: FROM AHL_SB_POSITION_RULES SB,

1679: -- cursor to get applicable SB rules for the given unit
1680: CURSOR get_appl_sb_rules_csr (c_uc_header_id NUMBER) IS
1681: SELECT SB.rule_id,
1682: SB.relationship_id
1683: FROM AHL_SB_POSITION_RULES SB,
1684: AHL_UNIT_CONFIG_HEADERS UC
1685: WHERE UC.unit_config_header_id = c_uc_header_id
1686: AND SB.mc_header_id = UC.master_config_id
1687: -- take only the rules which have MRs accomplished on the unit

Line 1695: FROM AHL_SB_POSITION_RULES SB2

1691: AND UE.csi_item_instance_id = UC.csi_item_instance_id -- SB MRs are effective on root node
1692: AND UE.accomplished_date IS NOT NULL)
1693: -- take only the MAX sequence rules for a position, among the accomplished MRs
1694: AND SB.rule_sequence = (SELECT MAX(SB2.rule_sequence)
1695: FROM AHL_SB_POSITION_RULES SB2
1696: WHERE SB2.relationship_id = SB.relationship_id
1697: AND EXISTS (SELECT 'X'
1698: FROM AHL_UNIT_EFFECTIVITIES_B UE
1699: WHERE UE.mr_header_id = SB2.mr_header_id