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 1725: FROM CSI_II_RELATIONSHIPS II, AHL_MC_RELATIONSHIPS REL

1721: II.SUBJECT_ID,
1722: REL.RELATIONSHIP_ID,
1723: REL.ACTIVE_START_DATE,
1724: REL.ACTIVE_END_DATE
1725: FROM CSI_II_RELATIONSHIPS II, AHL_MC_RELATIONSHIPS REL
1726: WHERE NVL(II.ACTIVE_START_DATE, SYSDATE - 1) <= SYSDATE AND
1727: NVL(II.ACTIVE_END_DATE, SYSDATE + 1) > SYSDATE AND
1728: II.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF' AND
1729: REL.RELATIONSHIP_ID =TO_NUMBER(II.POSITION_REFERENCE)

Line 1732: FROM CSI_II_RELATIONSHIPS

1728: II.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF' AND
1729: REL.RELATIONSHIP_ID =TO_NUMBER(II.POSITION_REFERENCE)
1730: AND II.RELATIONSHIP_ID IN
1731: (SELECT RELATIONSHIP_ID
1732: FROM CSI_II_RELATIONSHIPS
1733: START WITH SUBJECT_ID = c_start_instance_id AND
1734: NVL(ACTIVE_START_DATE, SYSDATE - 1) <= SYSDATE AND
1735: NVL(ACTIVE_END_DATE, SYSDATE + 1) > SYSDATE AND
1736: RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'

Line 1893: FROM csi_ii_relationships

1889: AND nvl(active_start_date, SYSDATE) <= SYSDATE;
1890:
1891: CURSOR get_parent_instance_csr IS
1892: SELECT object_id
1893: FROM csi_ii_relationships
1894: WHERE object_id IN (SELECT csi_item_instance_id
1895: FROM ahl_unit_config_headers
1896: WHERE nvl(active_end_date, SYSDATE+1) > SYSDATE
1897: AND nvl(active_start_date, SYSDATE) <= SYSDATE)