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

Line 1449: FROM CSI_II_RELATIONSHIPS II, AHL_MC_RELATIONSHIPS REL

1445: II.SUBJECT_ID,
1446: REL.RELATIONSHIP_ID,
1447: REL.ACTIVE_START_DATE,
1448: REL.ACTIVE_END_DATE
1449: FROM CSI_II_RELATIONSHIPS II, AHL_MC_RELATIONSHIPS REL
1450: WHERE NVL(II.ACTIVE_START_DATE, SYSDATE - 1) <= SYSDATE AND
1451: NVL(II.ACTIVE_END_DATE, SYSDATE + 1) > SYSDATE AND
1452: II.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF' AND
1453: REL.RELATIONSHIP_ID =TO_NUMBER(II.POSITION_REFERENCE)

Line 1456: FROM CSI_II_RELATIONSHIPS

1452: II.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF' AND
1453: REL.RELATIONSHIP_ID =TO_NUMBER(II.POSITION_REFERENCE)
1454: AND II.RELATIONSHIP_ID IN
1455: (SELECT RELATIONSHIP_ID
1456: FROM CSI_II_RELATIONSHIPS
1457: START WITH SUBJECT_ID = c_start_instance_id AND
1458: NVL(ACTIVE_START_DATE, SYSDATE - 1) <= SYSDATE AND
1459: NVL(ACTIVE_END_DATE, SYSDATE + 1) > SYSDATE AND
1460: RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'

Line 1617: FROM csi_ii_relationships

1613: AND nvl(active_start_date, SYSDATE) <= SYSDATE;
1614:
1615: CURSOR get_parent_instance_csr IS
1616: SELECT object_id
1617: FROM csi_ii_relationships
1618: WHERE object_id IN (SELECT csi_item_instance_id
1619: FROM ahl_unit_config_headers
1620: WHERE nvl(active_end_date, SYSDATE+1) > SYSDATE
1621: AND nvl(active_start_date, SYSDATE) <= SYSDATE)