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_UC_POS_NECES_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 70: FROM ahl_unit_config_headers

66: IS
67: ----
68: CURSOR get_uc_header_rec_csr(p_uc_header_id IN NUMBER) IS
69: SELECT csi_item_instance_id
70: FROM ahl_unit_config_headers
71: WHERE unit_config_header_id = p_uc_header_id
72: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
73: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1));
74: ---

Line 116: FROM ahl_unit_config_headers

112: SELECT object_id
113: FROM csi_ii_relationships
114: WHERE object_id IN
115: ( SELECT csi_item_instance_id
116: FROM ahl_unit_config_headers
117: WHERE trunc(nvl(active_start_date,sysdate-1)) <= trunc(sysdate)
118: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1)))
119: START WITH subject_id = p_csi_instance_id
120: AND relationship_type_code = 'COMPONENT-OF'

Line 131: FROM ahl_unit_config_headers uch

127: --
128: --With unit instance id, fetch the unit name.
129: CURSOR get_node_unit_csr (p_csi_instance_id IN NUMBER) IS
130: SELECT uch.name
131: FROM ahl_unit_config_headers uch
132: WHERE uch.csi_item_instance_id=p_csi_instance_id;
133:
134: --
135: l_api_version CONSTANT NUMBER := 1.0;

Line 140: l_unit_name ahl_unit_config_headers.name%TYPE;

136: l_api_name CONSTANT VARCHAR2(30) := 'List_Extra_Nodes';
137: l_top_instance_id NUMBER;
138: l_csi_id NUMBER;
139: l_unit_csi_id NUMBER;
140: l_unit_name ahl_unit_config_headers.name%TYPE;
141: l_item_number mtl_system_items_kfv.concatenated_segments%TYPE;
142: l_serial_number csi_item_instances.serial_number%TYPE;
143: --
144: BEGIN

Line 320: FROM ahl_unit_config_headers

316: IS
317: --
318: CURSOR get_uc_header_rec_csr(p_uc_header_id IN NUMBER) IS
319: SELECT csi_item_instance_id
320: FROM ahl_unit_config_headers
321: WHERE unit_config_header_id = p_uc_header_id
322: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
323: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1));
324: ---

Line 467: FROM ahl_unit_config_headers

463: IS
464: --
465: CURSOR get_uc_header_rec_csr(p_uc_header_id IN NUMBER) IS
466: SELECT csi_item_instance_id
467: FROM ahl_unit_config_headers
468: WHERE unit_config_header_id = p_uc_header_id
469: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
470: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1));
471: --

Line 492: FROM ahl_unit_config_headers uc, ahl_mc_relationships mc

488:
489: --Get the relationship id if instance is a uc header
490: CURSOR get_relnship_id_csr(c_csi_instance_id IN NUMBER) IS
491: SELECT mc.relationship_id
492: FROM ahl_unit_config_headers uc, ahl_mc_relationships mc
493: WHERE uc.master_config_id = mc.mc_header_id
494: AND mc.parent_relationship_id is null
495: AND uc.csi_item_instance_id = c_csi_instance_id
496: AND trunc(nvl(uc.active_start_date,sysdate)) <= trunc(sysdate)

Line 685: FROM ahl_unit_config_headers

681: ) IS
682: ----
683: CURSOR get_uc_header_rec_csr(p_uc_header_id IN NUMBER) IS
684: SELECT csi_item_instance_id
685: FROM ahl_unit_config_headers
686: WHERE unit_config_header_id = p_uc_header_id
687: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
688: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1));
689: --

Line 709: FROM ahl_unit_config_headers uc, ahl_mc_relationships mc

705:
706: --Get the relationship id if instance is a uc header
707: CURSOR get_relnship_id_csr(c_csi_instance_id IN NUMBER) IS
708: SELECT mc.relationship_id
709: FROM ahl_unit_config_headers uc, ahl_mc_relationships mc
710: WHERE uc.master_config_id = mc.mc_header_id
711: AND mc.parent_relationship_id is null
712: AND uc.csi_item_instance_id = c_csi_instance_id
713: AND trunc(nvl(uc.active_start_date,sysdate)) <= trunc(sysdate)

Line 976: FROM ahl_unit_config_headers uch

972:
973: --check that the instance is installed in a UC derived from the Rule's MC_HEADER_ID
974: CURSOR check_inst_in_uc_ofmc_csr(c_csi_instance_id IN NUMBER, c_mc_header_id IN NUMBER) IS
975: SELECT uch.csi_item_instance_id
976: FROM ahl_unit_config_headers uch
977: WHERE uch.master_config_id = c_mc_header_id
978: AND uch.csi_item_instance_id = c_csi_instance_id
979: UNION ALL
980: SELECT csi_ii.object_id

Line 984: FROM ahl_unit_config_headers

980: SELECT csi_ii.object_id
981: FROM csi_ii_relationships csi_ii
982: WHERE csi_ii.object_id IN
983: (SELECT csi_item_instance_id
984: FROM ahl_unit_config_headers
985: WHERE trunc(nvl(active_start_date,sysdate-1)) <= trunc(sysdate)
986: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
987: AND master_config_id = c_mc_header_id)
988: START WITH csi_ii.subject_id = c_csi_instance_id

Line 1134: FROM ahl_unit_config_headers

1130:
1131: -- Validate the UC and get the top instance
1132: CURSOR get_uc_header_rec_csr IS
1133: SELECT csi_item_instance_id
1134: FROM ahl_unit_config_headers
1135: WHERE unit_config_header_id = p_uc_header_id
1136: AND trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate)
1137: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1));
1138:

Line 1151: FROM ahl_unit_config_headers

1147: AND trunc(nvl(active_start_date, sysdate-1)) <= trunc(sysdate)
1148: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
1149: UNION ALL
1150: SELECT 1
1151: FROM ahl_unit_config_headers
1152: WHERE csi_item_instance_id = c_csi_instance_id
1153: AND trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate)
1154: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1)))
1155: UNION ALL

Line 1166: FROM ahl_unit_config_headers

1162: AND trunc(nvl(active_start_date, sysdate-1)) <= trunc(sysdate)
1163: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
1164: UNION ALL
1165: SELECT 1
1166: FROM ahl_unit_config_headers
1167: WHERE csi_item_instance_id = OUTER.subject_id
1168: AND trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate)
1169: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1)))
1170: START WITH object_id = c_csi_instance_id

Line 1469: FROM ahl_unit_config_headers

1465:
1466: -- Validate the UC and get the top instance
1467: CURSOR get_uc_header_rec_csr IS
1468: SELECT csi_item_instance_id
1469: FROM ahl_unit_config_headers
1470: WHERE unit_config_header_id = p_uc_header_id
1471: AND trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate)
1472: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1));
1473:

Line 1486: FROM ahl_unit_config_headers

1482: AND trunc(nvl(active_start_date, sysdate-1)) <= trunc(sysdate)
1483: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
1484: UNION ALL
1485: SELECT 1
1486: FROM ahl_unit_config_headers
1487: WHERE csi_item_instance_id = c_csi_instance_id
1488: AND trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate)
1489: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1)))
1490: UNION ALL

Line 1501: FROM ahl_unit_config_headers

1497: AND trunc(nvl(active_start_date, sysdate-1)) <= trunc(sysdate)
1498: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
1499: UNION ALL
1500: SELECT 1
1501: FROM ahl_unit_config_headers
1502: WHERE csi_item_instance_id = OUTER.subject_id
1503: AND trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate)
1504: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1)))
1505: START WITH object_id = c_csi_instance_id