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_UNIT_EFFECTIVITIES_B

Line 77: FROM AHL_UNIT_EFFECTIVITIES_B UE

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
76: AND EXISTS (SELECT 'X'
77: FROM AHL_UNIT_EFFECTIVITIES_B UE
78: WHERE UE.mr_header_id = SB.mr_header_id
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

Line 86: FROM AHL_UNIT_EFFECTIVITIES_B UE

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
88: AND UE.csi_item_instance_id = UC.csi_item_instance_id
89: AND UE.accomplished_date IS NOT NULL))
90: AND TRUNC(NVL(SB.active_start_date, SYSDATE)) <= TRUNC(SYSDATE)

Line 105: FROM AHL_UNIT_EFFECTIVITIES_B UE

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
104: AND EXISTS (SELECT 'X'
105: FROM AHL_UNIT_EFFECTIVITIES_B UE
106: WHERE UE.mr_header_id = SB.mr_header_id
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

Line 114: FROM AHL_UNIT_EFFECTIVITIES_B UE

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
116: AND UE.csi_item_instance_id = UC.csi_item_instance_id
117: AND UE.accomplished_date IS NOT NULL))
118: AND TRUNC(NVL(SB.active_start_date, SYSDATE)) <= TRUNC(SYSDATE)

Line 392: FROM AHL_UNIT_EFFECTIVITIES_B UE

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
391: AND EXISTS (SELECT 'X'
392: FROM AHL_UNIT_EFFECTIVITIES_B UE
393: WHERE UE.mr_header_id = SB.mr_header_id
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

Line 401: FROM AHL_UNIT_EFFECTIVITIES_B UE

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
403: AND UE.csi_item_instance_id = UC.csi_item_instance_id
404: AND UE.accomplished_date IS NOT NULL))
405: AND EXISTS (SELECT 'X'

Line 667: FROM AHL_UNIT_EFFECTIVITIES_B UE

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
666: AND EXISTS (SELECT 'X'
667: FROM AHL_UNIT_EFFECTIVITIES_B UE
668: WHERE UE.mr_header_id = SB.mr_header_id
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

Line 676: FROM AHL_UNIT_EFFECTIVITIES_B UE

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
678: AND UE.csi_item_instance_id = UC.csi_item_instance_id
679: AND UE.accomplished_date IS NOT NULL))
680: AND SB.relationship_id = c_relationship_id

Line 1689: FROM AHL_UNIT_EFFECTIVITIES_B UE

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
1688: AND EXISTS (SELECT 'X'
1689: FROM AHL_UNIT_EFFECTIVITIES_B UE
1690: WHERE UE.mr_header_id = SB.mr_header_id
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

Line 1698: FROM AHL_UNIT_EFFECTIVITIES_B UE

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
1700: AND UE.csi_item_instance_id = UC.csi_item_instance_id
1701: AND UE.accomplished_date IS NOT NULL))
1702: AND TRUNC(NVL(SB.active_start_date, SYSDATE)) <= TRUNC(SYSDATE)