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 AHL_UNIT_CONFIG_HEADERS

Line 505: ahl_unit_config_headers unit

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: )
509: AND c_instance_id NOT IN

Line 507: (SELECT csi_item_instance_id FROM ahl_unit_config_headers

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: )
509: AND c_instance_id NOT IN
510: (SELECT csi_item_instance_id FROM ahl_unit_config_headers
511: )

Line 510: (SELECT csi_item_instance_id FROM ahl_unit_config_headers

506: WHERE cir.object_id IN
507: (SELECT csi_item_instance_id FROM ahl_unit_config_headers
508: )
509: AND c_instance_id NOT IN
510: (SELECT csi_item_instance_id FROM ahl_unit_config_headers
511: )
512: AND ROWNUM = 1
513: START WITH cir.subject_id = c_instance_id
514: AND cir.relationship_type_code = 'COMPONENT-OF'

Line 524: ahl_unit_config_headers auc

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
528: AND auc.csi_item_instance_id = cirl.object_id;

Line 573: ahl_unit_config_headers unit

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)
577: AND NOT EXISTS (SELECT subject_id FROM csi_ii_relationships where subject_id = cir.object_id)

Line 574: /*WHERE cir.object_id IN (SELECT csi_item_instance_id FROM ahl_unit_config_headers)

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)
577: AND NOT EXISTS (SELECT subject_id FROM csi_ii_relationships where subject_id = cir.object_id)
578: AND ROWNUM =1

Line 576: WHERE EXISTS(SELECT csi_item_instance_id FROM ahl_unit_config_headers where csi_item_instance_id = cir.object_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
580: AND cir.relationship_type_code = 'COMPONENT-OF'

Line 963: l_parent_uc ahl_unit_config_headers.name%TYPE;

959: RETURN VARCHAR2
960: IS
961: x_parent_mc_header_id NUMBER;
962: x_parent_uc_instance_id NUMBER;
963: l_parent_uc ahl_unit_config_headers.name%TYPE;
964: l_uc_header_id NUMBER;
965: l_instance_id NUMBER;
966: l_masterConfig NUMBER;
967:

Line 975: FROM ahl_unit_config_headers

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)
977: )
978: START WITH subject_id = p_instance_id
979: AND relationship_type_code = 'COMPONENT-OF'

Line 990: FROM ahl_unit_config_headers

986:
987: CURSOR get_uc_header_id(c_instance_id NUMBER)
988: IS
989: SELECT name, master_config_id
990: FROM ahl_unit_config_headers
991: WHERE csi_item_instance_id = c_instance_id
992: AND TRUNC(NVL(active_end_date, SYSDATE+1)) > TRUNC(SYSDATE);
993:
994: l_configHeader get_uc_header_id%ROWTYPE;

Line 1044: l_master_config_id ahl_unit_config_headers.master_config_id%TYPE;

1040: RETURN VARCHAR2
1041: IS
1042: x_position fnd_lookups.Meaning%TYPE;
1043: l_position_ref_cd ahl_mc_relationships.position_ref_code%TYPE;
1044: l_master_config_id ahl_unit_config_headers.master_config_id%TYPE;
1045: l_child_inst NUMBER;
1046:
1047: BEGIN
1048: x_position := NULL;

Line 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;

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:
1058: IF(l_position_ref_cd IS NOT NULL) THEN
1059: SELECT meaning INTO x_position FROM fnd_lookups fnd WHERE fnd.lookup_type = 'AHL_POSITION_REFERENCE' AND fnd.lookup_code = l_position_ref_cd;