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_FMP_PVT dependencies on AHL_CONFIG_COMPONENTS

Line 1365: FROM ahl_config_components E

1361: WHERE B.pc_node_id = c_pc_node_id
1362: START WITH B.pc_node_id IN (select /*+ UNNEST */ pc_node_id
1363: from ahl_pc_associations itm, csi_item_instances csi,
1364: (select /*+ INDEX(E) */ object_id
1365: FROM ahl_config_components E
1366: START WITH E.subject_id = c_instance_id
1367: CONNECT BY E.subject_id = PRIOR E.object_id
1368: UNION ALL
1369: SELECT c_instance_id

Line 1387: FROM ahl_config_components E

1383: WHERE B.pc_node_id = c_pc_node_id
1384: START WITH B.pc_node_id IN (select /*+ UNNEST */ pc_node_id
1385: from ahl_pc_associations unit, ahl_unit_config_headers uc,
1386: (select /*+ INDEX(E) */ object_id
1387: FROM ahl_config_components E
1388: START WITH E.subject_id = c_instance_id
1389: CONNECT BY E.subject_id = PRIOR E.object_id
1390: UNION ALL
1391: SELECT c_instance_id

Line 1592: -- replaced csi_ii_relationships with ahl_config_components to fix bug# 9434441

1588: ORDER BY appl_mr.depth, appl_mr.subject_id; -- depth, subject_id
1589: */
1590:
1591: -- for the configuration components, get valid mr effectivities based on inventory items.
1592: -- replaced csi_ii_relationships with ahl_config_components to fix bug# 9434441
1593: -- performance fix for bug# 13629335: split cursor to do away with nvl(c_mr_header_id, A.mr_header_id)
1594: -- and removed one level of inner query
1595: CURSOR get_comp_mr_inv_csr(c_instance_id IN NUMBER, c_appln_usg_code IN VARCHAR2) IS
1596: SELECT A.mr_header_id, A.mr_effectivity_id,

Line 1608: FROM ahl_config_components a

1604: ii.serial_number --,
1605: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
1606: FROM ( SELECT a.subject_id
1607: --FROM csi_ii_relationships a
1608: FROM ahl_config_components a
1609: START WITH object_id = c_instance_id
1610: --AND relationship_type_code = 'COMPONENT-OF'
1611: --AND SYSDATE between trunc(nvl(active_start_date,sysdate))
1612: --AND trunc(NVL(active_end_date,sysdate+1))

Line 1653: FROM ahl_config_components a

1649: WHERE ciea1.instance_id = ii.instance_id AND ciea1.attribute_code = 'AHL_MFG_DATE'
1650: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
1651: ii.serial_number
1652: FROM ( SELECT a.subject_id
1653: FROM ahl_config_components a
1654: START WITH object_id = c_instance_id
1655: CONNECT BY object_id = PRIOR subject_id
1656: ) cir, csi_item_instances ii,
1657: ahl_mr_effectivities A, ahl_mr_headers_b MR

Line 1935: -- replaced csi_ii_relationships with ahl_config_components to fix bug# 9434441

1931: ORDER BY appl_mr.depth, appl_mr.subject_id; -- depth, subject_id
1932: */
1933:
1934: -- for the configuration components, get valid mr effectivities based on inventory items.
1935: -- replaced csi_ii_relationships with ahl_config_components to fix bug# 9434441
1936: CURSOR get_comp_vst_inv_csr(c_instance_id NUMBER, c_visit_type_code VARCHAR2) IS
1937: SELECT A.mr_header_id, A.mr_effectivity_id,
1938: A.pc_node_id,
1939: -- JKJain, NR Analysis and Forecasting

Line 1949: FROM ahl_config_components a

1945: cii.serial_number --,
1946: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
1947: FROM ( SELECT a.subject_id
1948: --FROM csi_ii_relationships a
1949: FROM ahl_config_components a
1950: START WITH object_id = c_instance_id
1951: --AND relationship_type_code = 'COMPONENT-OF'
1952: --AND SYSDATE between trunc(nvl(active_start_date,sysdate))
1953: --AND trunc(NVL(active_end_date,sysdate+1))

Line 2342: DELETE FROM AHL_CONFIG_COMPONENTS;

2338: END IF;
2339:
2340: -- initialize temp table.
2341: -- added to fix bug# 9434441.
2342: DELETE FROM AHL_CONFIG_COMPONENTS;
2343:
2344: -- populate temp table with config components
2345: --IF (p_components_flag = 'Y') THEN -- commented out as part of fix for bug# 9434441 as the pc_node_id validation needs the configuration to be populated.
2346: IF l_debug = 'Y' THEN

Line 4503: INSERT INTO AHL_CONFIG_COMPONENTS (subject_id, object_id, root_object_id, subj_child_exists)

4499: EXIT WHEN (l_subj_id_tbl.count = 0);
4500:
4501: -- insert into temp table.
4502: FORALL i IN l_subj_id_tbl.FIRST..l_subj_id_tbl.LAST
4503: INSERT INTO AHL_CONFIG_COMPONENTS (subject_id, object_id, root_object_id, subj_child_exists)
4504: values (l_subj_id_tbl(i), l_obj_id_tbl(i), l_root_instance_id, nvl(l_child_exists_tbl(i), 'N'));
4505:
4506: l_subj_id_tbl.delete;
4507: l_obj_id_tbl.delete;

Line 4554: FROM ahl_config_components E

4550: WHERE B.pc_node_id = c_pc_node_id
4551: START WITH B.pc_node_id IN (select pc_node_id
4552: from ahl_pc_associations itm, csi_item_instances csi,
4553: (select object_id
4554: FROM ahl_config_components E
4555: START WITH E.subject_id = c_instance_id
4556: CONNECT BY E.subject_id = PRIOR E.object_id
4557: UNION ALL
4558: SELECT c_instance_id

Line 4575: FROM ahl_config_components E

4571: WHERE B.pc_node_id = c_pc_node_id
4572: START WITH B.pc_node_id IN (select pc_node_id
4573: from ahl_pc_associations unit, ahl_unit_config_headers uc,
4574: (select object_id
4575: FROM ahl_config_components E
4576: START WITH E.subject_id = c_instance_id
4577: CONNECT BY E.subject_id = PRIOR E.object_id
4578: UNION ALL
4579: SELECT c_instance_id

Line 4600: -- replaced csi_ii_relationships with ahl_config_components to fix bug# 9434441

4596:
4597: l_get_mr_attri get_mr_attri%ROWTYPE;
4598:
4599: -- for the configuration components, get valid mr effectivities based on inventory items.
4600: -- replaced csi_ii_relationships with ahl_config_components to fix bug# 9434441
4601: CURSOR get_comp_mr_inv_csr(c_instance_id NUMBER, c_mr_header_id NUMBER) IS
4602: SELECT A.mr_header_id, A.mr_effectivity_id,
4603: A.pc_node_id,
4604: ii.instance_id subject_id,

Line 4611: FROM ahl_config_components a

4607: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
4608: ii.serial_number
4609: FROM ( SELECT a.subject_id
4610: --FROM csi_ii_relationships a
4611: FROM ahl_config_components a
4612: START WITH object_id = c_instance_id
4613: --AND relationship_type_code = 'COMPONENT-OF'
4614: --AND SYSDATE between trunc(nvl(active_start_date,sysdate))
4615: --AND trunc(NVL(active_end_date,sysdate+1))

Line 4837: DELETE FROM AHL_CONFIG_COMPONENTS;

4833: END IF;
4834:
4835: -- initialize temp table.
4836: -- added to fix bug# 9434441.
4837: DELETE FROM AHL_CONFIG_COMPONENTS;
4838:
4839: -- populate temp table with config components
4840: --IF (p_components_flag = 'Y') THEN -- commented out as part of fix for bug# 9434441 as the pc_node_id validation needs the configuration to be populated.
4841: IF l_debug = 'Y' THEN