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_REPORT_UTILS_PVT dependencies on CSI_II_RELATIONSHIPS

Line 504: FROM csi_ii_relationships cir,

500: l_get_first_instance NUMBER;
501:
502: CURSOR c_get_first_instance(c_instance_id NUMBER) IS
503: SELECT UNIQUE cir.object_id INST_ID
504: FROM csi_ii_relationships cir,
505: ahl_unit_config_headers unit
506: WHERE cir.object_id IN
507: (SELECT csi_item_instance_id FROM ahl_unit_config_headers
508: )

Line 523: FROM csi_ii_relationships cirl,

519:
520: UNION ALL
521:
522: SELECT UNIQUE cirl.object_id
523: FROM csi_ii_relationships cirl,
524: ahl_unit_config_headers auc
525: WHERE cirl.object_id = c_instance_id
526: AND cirl.relationship_type_code = 'COMPONENT-OF'
527: AND NVL(cirl.active_end_date, sysdate + 1) > sysdate

Line 572: FROM csi_ii_relationships cir,

568: l_get_root_instance NUMBER;
569:
570: CURSOR c_get_root_instance(c_instance_id NUMBER) IS
571: SELECT UNIQUE cir.object_id INST_ID
572: FROM csi_ii_relationships cir,
573: ahl_unit_config_headers unit
574: /*WHERE cir.object_id IN (SELECT csi_item_instance_id FROM ahl_unit_config_headers)
575: AND cir.object_id NOT IN (SELECT subject_id FROM csi_ii_relationships)*/
576: WHERE EXISTS(SELECT csi_item_instance_id FROM ahl_unit_config_headers where csi_item_instance_id = cir.object_id)

Line 575: AND cir.object_id NOT IN (SELECT subject_id FROM csi_ii_relationships)*/

571: SELECT UNIQUE cir.object_id INST_ID
572: FROM csi_ii_relationships cir,
573: ahl_unit_config_headers unit
574: /*WHERE cir.object_id IN (SELECT csi_item_instance_id FROM ahl_unit_config_headers)
575: AND cir.object_id NOT IN (SELECT subject_id FROM csi_ii_relationships)*/
576: WHERE EXISTS(SELECT csi_item_instance_id FROM ahl_unit_config_headers where csi_item_instance_id = cir.object_id)
577: AND NOT EXISTS (SELECT subject_id FROM csi_ii_relationships where subject_id = cir.object_id)
578: AND ROWNUM =1
579: START WITH cir.object_id = c_instance_id

Line 577: AND NOT EXISTS (SELECT subject_id FROM csi_ii_relationships where subject_id = cir.object_id)

573: ahl_unit_config_headers unit
574: /*WHERE cir.object_id IN (SELECT csi_item_instance_id FROM ahl_unit_config_headers)
575: AND cir.object_id NOT IN (SELECT subject_id FROM csi_ii_relationships)*/
576: WHERE EXISTS(SELECT csi_item_instance_id FROM ahl_unit_config_headers where csi_item_instance_id = cir.object_id)
577: AND NOT EXISTS (SELECT subject_id FROM csi_ii_relationships where subject_id = cir.object_id)
578: AND ROWNUM =1
579: START WITH cir.object_id = c_instance_id
580: AND cir.relationship_type_code = 'COMPONENT-OF'
581: AND NVL(cir.active_end_date, sysdate + 1) > sysdate

Line 972: FROM csi_ii_relationships

968: CURSOR get_parent_uc
969: IS
970: SELECT object_id,
971: level "HR_LEVEL"
972: FROM csi_ii_relationships
973: WHERE object_id IN
974: (SELECT csi_item_instance_id
975: FROM ahl_unit_config_headers
976: WHERE TRUNC(NVL(active_end_date, SYSDATE+1)) > TRUNC(SYSDATE)

Line 1022: SELECT COUNT(object_id) INTO l_masterConfig FROM csi_ii_relationships WHERE object_id = P_INSTANCE_ID AND relationship_type_code = 'COMPONENT-OF';

1018: IF(ahl_report_utils_pvt.get_root_instance(P_INSTANCE_ID) = x_parent_uc_instance_id) THEN
1019: x_parent_uc_instance_id := NULL;
1020: l_parent_uc := NULL;
1021: END IF;
1022: SELECT COUNT(object_id) INTO l_masterConfig FROM csi_ii_relationships WHERE object_id = P_INSTANCE_ID AND relationship_type_code = 'COMPONENT-OF';
1023: EXIT WHEN (l_masterConfig > 0);
1024: END IF;
1025:
1026: CLOSE get_uc_header_id;

Line 1050: SELECT COUNT(subject_id) INTO l_child_inst FROM csi_ii_relationships WHERE subject_id = p_instance_id;

1046:
1047: BEGIN
1048: x_position := NULL;
1049:
1050: SELECT COUNT(subject_id) INTO l_child_inst FROM csi_ii_relationships WHERE subject_id = p_instance_id;
1051:
1052: IF(l_child_inst > 0) THEN
1053: SELECT position_ref_code INTO l_position_ref_cd FROM ahl_mc_relationships WHERE relationship_id IN (SELECT position_reference FROM csi_ii_relationships WHERE subject_id = p_instance_id AND relationship_type_code = 'COMPONENT-OF') AND ROWNUM < 2;
1054: ELSE

Line 1053: SELECT position_ref_code INTO l_position_ref_cd FROM ahl_mc_relationships WHERE relationship_id IN (SELECT position_reference FROM csi_ii_relationships WHERE subject_id = p_instance_id AND relationship_type_code = 'COMPONENT-OF') AND ROWNUM < 2;

1049:
1050: SELECT COUNT(subject_id) INTO l_child_inst FROM csi_ii_relationships WHERE subject_id = p_instance_id;
1051:
1052: IF(l_child_inst > 0) THEN
1053: SELECT position_ref_code INTO l_position_ref_cd FROM ahl_mc_relationships WHERE relationship_id IN (SELECT position_reference FROM csi_ii_relationships WHERE subject_id = p_instance_id AND relationship_type_code = 'COMPONENT-OF') AND ROWNUM < 2;
1054: ELSE
1055: SELECT position_ref_code INTO l_position_ref_cd FROM ahl_mc_relationships WHERE mc_header_id IN (SELECT master_config_id FROM ahl_unit_config_headers WHERE csi_item_instance_id = P_INSTANCE_ID) AND item_group_id = P_ITEM_GRP_ID AND ROWNUM < 2;
1056: END IF;
1057: