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_LTP_MTL_REQ_PVT dependencies on AHL_SB_POSITION_RULES

Line 2025: FROM ahl_sb_position_rules SB,

2021: rule_sequence
2022: FROM (
2023: SELECT SB.rule_id,
2024: SB.rule_sequence
2025: FROM ahl_sb_position_rules SB,
2026: ahl_unit_config_headers UC
2027: WHERE UC.unit_config_header_id = c_uc_header_id
2028: AND SB.mc_header_id = UC.master_config_id
2029: -- take only the rules which have MRs accomplished on the unit

Line 2037: FROM ahl_sb_position_rules SB2

2033: AND UE.csi_item_instance_id = UC.csi_item_instance_id -- SB MRs are effective on root node
2034: AND UE.accomplished_date IS NOT NULL)
2035: -- take only the MAX sequence rules for a position, among the accomplished MRs
2036: AND SB.rule_sequence = (SELECT MAX(SB2.rule_sequence)
2037: FROM ahl_sb_position_rules SB2
2038: WHERE SB2.relationship_id = SB.relationship_id
2039: AND EXISTS (SELECT 'X'
2040: FROM ahl_unit_effectivities_b UE
2041: WHERE UE.mr_header_id = SB2.mr_header_id

Line 2050: FROM AHL_SB_POSITION_RULES SB,

2046: AND TRUNC(NVL(SB.active_end_date, SYSDATE+1)) > TRUNC(SYSDATE)
2047: UNION ALL
2048: SELECT SB.rule_id,
2049: SB.rule_sequence
2050: FROM AHL_SB_POSITION_RULES SB,
2051: AHL_VISIT_TASKS_B VT,
2052: AHL_UNIT_CONFIG_HEADERS UC
2053: WHERE UC.unit_config_header_id = c_uc_header_id
2054: AND SB.mc_header_id = UC.master_config_id

Line 2061: FROM AHL_SB_POSITION_RULES SB2

2057: AND VT.mr_id = SB.mr_header_id
2058: AND VT.status_code NOT IN ('CANCELLED', 'DELETED')
2059: -- take only the MAX sequence rules for a position
2060: AND SB.rule_sequence = (SELECT MAX(SB2.rule_sequence)
2061: FROM AHL_SB_POSITION_RULES SB2
2062: WHERE SB2.relationship_id = SB.relationship_id
2063: AND SB2.mr_header_id = SB.mr_header_id)
2064: AND SB.relationship_id = c_relationship_id
2065: AND TRUNC(NVL(SB.active_start_date, SYSDATE)) <= TRUNC(SYSDATE)

Line 2558: FROM ahl_sb_position_rules SB,

2554: rule_sequence
2555: FROM (
2556: SELECT SB.rule_id,
2557: SB.rule_sequence
2558: FROM ahl_sb_position_rules SB,
2559: ahl_unit_config_headers UC
2560: WHERE UC.unit_config_header_id = c_uc_header_id
2561: AND SB.mc_header_id = UC.master_config_id
2562: -- take only the rules which have MRs accomplished on the unit

Line 2570: FROM ahl_sb_position_rules SB2

2566: AND UE.csi_item_instance_id = UC.csi_item_instance_id -- SB MRs are effective on root node
2567: AND UE.accomplished_date IS NOT NULL)
2568: -- take only the MAX sequence rules for a position, among the accomplished MRs
2569: AND SB.rule_sequence = (SELECT MAX(SB2.rule_sequence)
2570: FROM ahl_sb_position_rules SB2
2571: WHERE SB2.relationship_id = SB.relationship_id
2572: AND EXISTS (SELECT 'X'
2573: FROM ahl_unit_effectivities_b UE
2574: WHERE UE.mr_header_id = SB2.mr_header_id

Line 2583: FROM AHL_SB_POSITION_RULES SB,

2579: AND TRUNC(NVL(SB.active_end_date, SYSDATE+1)) > TRUNC(SYSDATE)
2580: UNION ALL
2581: SELECT SB.rule_id,
2582: SB.rule_sequence
2583: FROM AHL_SB_POSITION_RULES SB,
2584: AHL_VISIT_TASKS_B VT,
2585: AHL_UNIT_CONFIG_HEADERS UC
2586: WHERE UC.unit_config_header_id = c_uc_header_id
2587: AND SB.mc_header_id = UC.master_config_id

Line 2594: FROM AHL_SB_POSITION_RULES SB2

2590: AND VT.mr_id = SB.mr_header_id
2591: AND VT.status_code NOT IN ('CANCELLED', 'DELETED')
2592: -- take only the MAX sequence rules for a position
2593: AND SB.rule_sequence = (SELECT MAX(SB2.rule_sequence)
2594: FROM AHL_SB_POSITION_RULES SB2
2595: WHERE SB2.relationship_id = SB.relationship_id
2596: AND SB2.mr_header_id = SB.mr_header_id)
2597: AND SB.relationship_id = c_relationship_id
2598: AND TRUNC(NVL(SB.active_start_date, SYSDATE)) <= TRUNC(SYSDATE)