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

Line 1508: FROM csi_ii_relationships root

1504: IS
1505:
1506: CURSOR csi_root_instance_csr (p_instance_id IN NUMBER) IS
1507: SELECT root.object_id
1508: FROM csi_ii_relationships root
1509: WHERE NOT EXISTS (SELECT 'x'
1510: FROM csi_ii_relationships
1511: WHERE subject_id = root.object_id
1512: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 1510: FROM csi_ii_relationships

1506: CURSOR csi_root_instance_csr (p_instance_id IN NUMBER) IS
1507: SELECT root.object_id
1508: FROM csi_ii_relationships root
1509: WHERE NOT EXISTS (SELECT 'x'
1510: FROM csi_ii_relationships
1511: WHERE subject_id = root.object_id
1512: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
1513: )
1514: START WITH root.subject_id = p_instance_id

Line 1552: FROM csi_ii_relationships

1548: IS
1549:
1550: CURSOR csi_config_tree_csr ( p_csi_root_instance_id IN NUMBER) IS
1551: SELECT subject_id , object_id, position_reference
1552: FROM csi_ii_relationships
1553: START WITH object_id = p_csi_root_instance_id
1554: AND relationship_type_code = 'COMPONENT-OF'
1555: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
1556: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 1946: FROM CSI_II_RELATIONSHIPS A

1942: WITH II AS (SELECT p_csi_item_instance_id instance_id
1943: FROM DUAL
1944: UNION ALL
1945: SELECT A.SUBJECT_ID INSTANCE_ID
1946: FROM CSI_II_RELATIONSHIPS A
1947: START WITH OBJECT_ID = p_csi_item_instance_id
1948: AND RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
1949: AND SYSDATE BETWEEN TRUNC(NVL(ACTIVE_START_DATE,SYSDATE))
1950: AND TRUNC(NVL(ACTIVE_END_DATE, SYSDATE+1))

Line 2220: FROM csi_ii_relationships

2216: -- Per UC 11.5.10 enhancements, instead of traversing MC; we traverse UC and get the position
2217: -- reference.
2218: CURSOR ahl_unit_config_csr (p_csi_item_instance_id IN NUMBER) IS
2219: SELECT to_number(position_reference) position_reference
2220: FROM csi_ii_relationships
2221: START WITH subject_id = p_csi_item_instance_id
2222: AND relationship_type_code = 'COMPONENT-OF'
2223: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
2224: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 8127: FROM csi_ii_relationships

8123:
8124: -- get the configuration structure.(G_config_node_tbl).
8125: CURSOR csi_reln_csr ( p_csi_item_instance_id IN NUMBER) IS
8126: SELECT position_reference
8127: FROM csi_ii_relationships
8128: WHERE subject_id = p_csi_item_instance_id
8129: AND relationship_type_code = 'COMPONENT-OF'
8130: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
8131: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1));

Line 11170: (select object_id from csi_ii_relationships parent

11166: SELECT instance_id from
11167: (SELECT DISTINCT nvl(root_instance_id, instance_id) instance_id from
11168: (
11169: SELECT cii.instance_id,
11170: (select object_id from csi_ii_relationships parent
11171: where not exists (select 'x' from csi_ii_relationships
11172: where subject_id = parent.object_id and
11173: relationship_type_code = 'COMPONENT-OF' and
11174: trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate) and

Line 11171: where not exists (select 'x' from csi_ii_relationships

11167: (SELECT DISTINCT nvl(root_instance_id, instance_id) instance_id from
11168: (
11169: SELECT cii.instance_id,
11170: (select object_id from csi_ii_relationships parent
11171: where not exists (select 'x' from csi_ii_relationships
11172: where subject_id = parent.object_id and
11173: relationship_type_code = 'COMPONENT-OF' and
11174: trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate) and
11175: trunc(sysdate) < trunc(nvl(active_end_date,sysdate+1)))

Line 11247: (select object_id from csi_ii_relationships parent

11243: SELECT instance_id from
11244: (SELECT DISTINCT nvl(root_instance_id, instance_id) instance_id from
11245: (
11246: SELECT cii.instance_id,
11247: (select object_id from csi_ii_relationships parent
11248: where not exists (select 'x' from csi_ii_relationships
11249: where subject_id = parent.object_id and
11250: relationship_type_code = 'COMPONENT-OF' and
11251: trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate) and

Line 11248: where not exists (select 'x' from csi_ii_relationships

11244: (SELECT DISTINCT nvl(root_instance_id, instance_id) instance_id from
11245: (
11246: SELECT cii.instance_id,
11247: (select object_id from csi_ii_relationships parent
11248: where not exists (select 'x' from csi_ii_relationships
11249: where subject_id = parent.object_id and
11250: relationship_type_code = 'COMPONENT-OF' and
11251: trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate) and
11252: trunc(sysdate) < trunc(nvl(active_end_date,sysdate+1)))

Line 11810: (select object_id from csi_ii_relationships parent

11806: SELECT instance_id from
11807: (SELECT DISTINCT nvl(root_instance_id, instance_id) instance_id from
11808: (
11809: SELECT cii.instance_id,
11810: (select object_id from csi_ii_relationships parent
11811: where not exists (select 'x' from csi_ii_relationships
11812: where subject_id = parent.object_id and
11813: relationship_type_code = 'COMPONENT-OF' and
11814: trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate) and

Line 11811: where not exists (select 'x' from csi_ii_relationships

11807: (SELECT DISTINCT nvl(root_instance_id, instance_id) instance_id from
11808: (
11809: SELECT cii.instance_id,
11810: (select object_id from csi_ii_relationships parent
11811: where not exists (select 'x' from csi_ii_relationships
11812: where subject_id = parent.object_id and
11813: relationship_type_code = 'COMPONENT-OF' and
11814: trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate) and
11815: trunc(sysdate) < trunc(nvl(active_end_date,sysdate+1)))

Line 11870: (select object_id from csi_ii_relationships parent

11866: SELECT instance_id from
11867: (SELECT DISTINCT nvl(root_instance_id, instance_id) instance_id from
11868: (
11869: SELECT cii.instance_id,
11870: (select object_id from csi_ii_relationships parent
11871: where not exists (select 'x' from csi_ii_relationships
11872: where subject_id = parent.object_id and
11873: relationship_type_code = 'COMPONENT-OF' and
11874: trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate) and

Line 11871: where not exists (select 'x' from csi_ii_relationships

11867: (SELECT DISTINCT nvl(root_instance_id, instance_id) instance_id from
11868: (
11869: SELECT cii.instance_id,
11870: (select object_id from csi_ii_relationships parent
11871: where not exists (select 'x' from csi_ii_relationships
11872: where subject_id = parent.object_id and
11873: relationship_type_code = 'COMPONENT-OF' and
11874: trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate) and
11875: trunc(sysdate) < trunc(nvl(active_end_date,sysdate+1)))

Line 11943: (select object_id from csi_ii_relationships parent

11939: FROM (
11940: SELECT DISTINCT nvl(Root_instance_id, csi_item_instance_id) csi_item_instance_id
11941: FROM (
11942: SELECT DISTINCT UE.csi_item_instance_id,
11943: (select object_id from csi_ii_relationships parent
11944: where not exists (select 'x' from csi_ii_relationships
11945: where subject_id = parent.object_id and
11946: trunc(sysdate) < trunc(nvl(active_end_date,sysdate+1)))
11947: start with parent.subject_id = UE.CSI_ITEM_INSTANCE_ID and

Line 11944: where not exists (select 'x' from csi_ii_relationships

11940: SELECT DISTINCT nvl(Root_instance_id, csi_item_instance_id) csi_item_instance_id
11941: FROM (
11942: SELECT DISTINCT UE.csi_item_instance_id,
11943: (select object_id from csi_ii_relationships parent
11944: where not exists (select 'x' from csi_ii_relationships
11945: where subject_id = parent.object_id and
11946: trunc(sysdate) < trunc(nvl(active_end_date,sysdate+1)))
11947: start with parent.subject_id = UE.CSI_ITEM_INSTANCE_ID and
11948: parent.relationship_type_code = 'COMPONENT-OF' and