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 1729: FROM csi_ii_relationships root

1725: IS
1726:
1727: CURSOR csi_root_instance_csr (p_instance_id IN NUMBER) IS
1728: SELECT root.object_id
1729: FROM csi_ii_relationships root
1730: WHERE NOT EXISTS (SELECT 'x'
1731: FROM csi_ii_relationships
1732: WHERE subject_id = root.object_id
1733: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 1731: FROM csi_ii_relationships

1727: CURSOR csi_root_instance_csr (p_instance_id IN NUMBER) IS
1728: SELECT root.object_id
1729: FROM csi_ii_relationships root
1730: WHERE NOT EXISTS (SELECT 'x'
1731: FROM csi_ii_relationships
1732: WHERE subject_id = root.object_id
1733: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
1734: )
1735: START WITH root.subject_id = p_instance_id

Line 1773: FROM csi_ii_relationships

1769: IS
1770:
1771: CURSOR csi_config_tree_csr ( p_csi_root_instance_id IN NUMBER) IS
1772: SELECT subject_id , object_id, position_reference
1773: FROM csi_ii_relationships
1774: START WITH object_id = p_csi_root_instance_id
1775: AND relationship_type_code = 'COMPONENT-OF'
1776: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
1777: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 2488: FROM CSI_II_RELATIONSHIPS A

2484: WITH II AS (SELECT p_csi_item_instance_id instance_id
2485: FROM DUAL
2486: UNION ALL
2487: SELECT A.SUBJECT_ID INSTANCE_ID
2488: FROM CSI_II_RELATIONSHIPS A
2489: START WITH OBJECT_ID = p_csi_item_instance_id
2490: AND RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
2491: AND SYSDATE BETWEEN TRUNC(NVL(ACTIVE_START_DATE,SYSDATE))
2492: AND TRUNC(NVL(ACTIVE_END_DATE, SYSDATE+1))

Line 2512: FROM CSI_II_RELATIONSHIPS A

2508: WITH II AS (SELECT p_csi_item_instance_id instance_id
2509: FROM DUAL
2510: UNION ALL
2511: SELECT A.SUBJECT_ID INSTANCE_ID
2512: FROM CSI_II_RELATIONSHIPS A
2513: START WITH OBJECT_ID = p_csi_item_instance_id
2514: AND RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
2515: AND SYSDATE BETWEEN TRUNC(NVL(ACTIVE_START_DATE,SYSDATE))
2516: AND TRUNC(NVL(ACTIVE_END_DATE, SYSDATE+1))

Line 2849: FROM csi_ii_relationships

2845: -- Per UC 11.5.10 enhancements, instead of traversing MC; we traverse UC and get the position
2846: -- reference.
2847: CURSOR ahl_unit_config_csr (p_csi_item_instance_id IN NUMBER) IS
2848: SELECT to_number(position_reference) position_reference
2849: FROM csi_ii_relationships
2850: START WITH subject_id = p_csi_item_instance_id
2851: AND relationship_type_code = 'COMPONENT-OF'
2852: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
2853: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 9606: FROM csi_ii_relationships

9602:
9603: -- get the configuration structure.(G_config_node_tbl).
9604: CURSOR csi_reln_csr ( p_csi_item_instance_id IN NUMBER) IS
9605: SELECT position_reference
9606: FROM csi_ii_relationships
9607: WHERE subject_id = p_csi_item_instance_id
9608: AND relationship_type_code = 'COMPONENT-OF'
9609: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
9610: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1));

Line 12809: from csi_ii_relationships iir

12805: AND sysdate < nvl(ii.active_end_date,sysdate+1)
12806: AND unit_config_status_code <> 'DRAFT'
12807: AND parent_uc_header_id IS NULL
12808: AND NOT EXISTS (select 'x'
12809: from csi_ii_relationships iir
12810: where iir.relationship_type_code = 'COMPONENT-OF'
12811: and iir.subject_id = uc.csi_item_instance_id
12812: and trunc(nvl(iir.active_start_date, sysdate)) <= trunc(sysdate)
12813: and trunc(sysdate) < trunc(nvl(iir.active_end_date,sysdate+1))

Line 12831: from csi_ii_relationships iir

12827: AND sysdate < nvl(ii.active_end_date,sysdate+1)
12828: AND unit_config_status_code <> 'DRAFT'
12829: AND parent_uc_header_id IS NULL
12830: AND NOT EXISTS (select 'x'
12831: from csi_ii_relationships iir
12832: where iir.relationship_type_code = 'COMPONENT-OF'
12833: and iir.subject_id = uc.csi_item_instance_id
12834: and trunc(nvl(iir.active_start_date, sysdate)) <= trunc(sysdate)
12835: and trunc(sysdate) < trunc(nvl(iir.active_end_date,sysdate+1))

Line 12857: (select object_id from csi_ii_relationships parent

12853: SELECT instance_id from
12854: (SELECT DISTINCT nvl(root_instance_id, instance_id) instance_id from
12855: (
12856: SELECT cii.instance_id,
12857: (select object_id from csi_ii_relationships parent
12858: where not exists (select 'x' from csi_ii_relationships
12859: where subject_id = parent.object_id and
12860: relationship_type_code = 'COMPONENT-OF' and
12861: trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate) and

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

12854: (SELECT DISTINCT nvl(root_instance_id, instance_id) instance_id from
12855: (
12856: SELECT cii.instance_id,
12857: (select object_id from csi_ii_relationships parent
12858: where not exists (select 'x' from csi_ii_relationships
12859: where subject_id = parent.object_id and
12860: relationship_type_code = 'COMPONENT-OF' and
12861: trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate) and
12862: trunc(sysdate) < trunc(nvl(active_end_date,sysdate+1)))

Line 12934: (select object_id from csi_ii_relationships parent

12930: SELECT instance_id from
12931: (SELECT DISTINCT nvl(root_instance_id, instance_id) instance_id from
12932: (
12933: SELECT cii.instance_id,
12934: (select object_id from csi_ii_relationships parent
12935: where not exists (select 'x' from csi_ii_relationships
12936: where subject_id = parent.object_id and
12937: relationship_type_code = 'COMPONENT-OF' and
12938: trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate) and

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

12931: (SELECT DISTINCT nvl(root_instance_id, instance_id) instance_id from
12932: (
12933: SELECT cii.instance_id,
12934: (select object_id from csi_ii_relationships parent
12935: where not exists (select 'x' from csi_ii_relationships
12936: where subject_id = parent.object_id and
12937: relationship_type_code = 'COMPONENT-OF' and
12938: trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate) and
12939: trunc(sysdate) < trunc(nvl(active_end_date,sysdate+1)))

Line 13672: (select object_id from csi_ii_relationships parent

13668: SELECT instance_id from
13669: (SELECT DISTINCT nvl(root_instance_id, instance_id) instance_id from
13670: (
13671: SELECT cii.instance_id,
13672: (select object_id from csi_ii_relationships parent
13673: where not exists (select 'x' from csi_ii_relationships
13674: where subject_id = parent.object_id and
13675: relationship_type_code = 'COMPONENT-OF' and
13676: trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate) and

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

13669: (SELECT DISTINCT nvl(root_instance_id, instance_id) instance_id from
13670: (
13671: SELECT cii.instance_id,
13672: (select object_id from csi_ii_relationships parent
13673: where not exists (select 'x' from csi_ii_relationships
13674: where subject_id = parent.object_id and
13675: relationship_type_code = 'COMPONENT-OF' and
13676: trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate) and
13677: trunc(sysdate) < trunc(nvl(active_end_date,sysdate+1)))

Line 13732: (select object_id from csi_ii_relationships parent

13728: SELECT instance_id from
13729: (SELECT DISTINCT nvl(root_instance_id, instance_id) instance_id from
13730: (
13731: SELECT cii.instance_id,
13732: (select object_id from csi_ii_relationships parent
13733: where not exists (select 'x' from csi_ii_relationships
13734: where subject_id = parent.object_id and
13735: relationship_type_code = 'COMPONENT-OF' and
13736: trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate) and

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

13729: (SELECT DISTINCT nvl(root_instance_id, instance_id) instance_id from
13730: (
13731: SELECT cii.instance_id,
13732: (select object_id from csi_ii_relationships parent
13733: where not exists (select 'x' from csi_ii_relationships
13734: where subject_id = parent.object_id and
13735: relationship_type_code = 'COMPONENT-OF' and
13736: trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate) and
13737: trunc(sysdate) < trunc(nvl(active_end_date,sysdate+1)))

Line 13805: (select object_id from csi_ii_relationships parent

13801: FROM (
13802: SELECT DISTINCT nvl(Root_instance_id, csi_item_instance_id) csi_item_instance_id
13803: FROM (
13804: SELECT DISTINCT UE.csi_item_instance_id,
13805: (select object_id from csi_ii_relationships parent
13806: where not exists (select 'x' from csi_ii_relationships
13807: where subject_id = parent.object_id and
13808: trunc(sysdate) < trunc(nvl(active_end_date,sysdate+1)))
13809: start with parent.subject_id = UE.CSI_ITEM_INSTANCE_ID and

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

13802: SELECT DISTINCT nvl(Root_instance_id, csi_item_instance_id) csi_item_instance_id
13803: FROM (
13804: SELECT DISTINCT UE.csi_item_instance_id,
13805: (select object_id from csi_ii_relationships parent
13806: where not exists (select 'x' from csi_ii_relationships
13807: where subject_id = parent.object_id and
13808: trunc(sysdate) < trunc(nvl(active_end_date,sysdate+1)))
13809: start with parent.subject_id = UE.CSI_ITEM_INSTANCE_ID and
13810: parent.relationship_type_code = 'COMPONENT-OF' and

Line 14531: FROM csi_ii_relationships

14527:
14528: -- get the configuration structure.(G_config_node_tbl).
14529: CURSOR csi_reln_csr ( p_csi_item_instance_id IN NUMBER) IS
14530: SELECT position_reference
14531: FROM csi_ii_relationships
14532: WHERE subject_id = p_csi_item_instance_id
14533: AND relationship_type_code = 'COMPONENT-OF'
14534: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
14535: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1));

Line 16242: FROM csi_ii_relationships

16238:
16239: -- get the configuration structure.(G_config_node_tbl).
16240: CURSOR csi_reln_csr ( p_csi_item_instance_id IN NUMBER) IS
16241: SELECT position_reference
16242: FROM csi_ii_relationships
16243: WHERE subject_id = p_csi_item_instance_id
16244: AND relationship_type_code = 'COMPONENT-OF'
16245: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
16246: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1));