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

Line 1698: AND NOT EXISTS (SELECT 'X' FROM CSI_II_RELATIONSHIPS CIR

1694: AND ACTIVE_START_DATE <= SYSDATE
1695: AND ((ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE > SYSDATE))
1696: --AND LOCATION_TYPE_CODE = 'WIP'
1697: --AND LOCATION_ID = p_wip_location
1698: AND NOT EXISTS (SELECT 'X' FROM CSI_II_RELATIONSHIPS CIR
1699: WHERE CIR.SUBJECT_ID = CII.INSTANCE_ID
1700: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
1701: --AND SYSDATE BETWEEN NVL(ACTIVE_START_DATE,SYSDATE) AND NVL(ACTIVE_END_DATE,SYSDATE));
1702: AND NVL(ACTIVE_START_DATE,SYSDATE) <= SYSDATE

Line 1715: AND NOT EXISTS (SELECT 'X' FROM CSI_II_RELATIONSHIPS CIR

1711: WHERE INVENTORY_ITEM_ID = p_item_id
1712: AND SERIAL_NUMBER = p_serial_num
1713: AND ACTIVE_START_DATE <= SYSDATE
1714: AND ((ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE > SYSDATE))
1715: AND NOT EXISTS (SELECT 'X' FROM CSI_II_RELATIONSHIPS CIR
1716: WHERE CIR.SUBJECT_ID = CII.INSTANCE_ID
1717: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
1718: AND SYSDATE BETWEEN NVL(ACTIVE_START_DATE,SYSDATE) AND NVL(ACTIVE_END_DATE,SYSDATE));
1719:

Line 2464: l_sql := l_sql || ' AND NOT EXISTS (SELECT null FROM CSI_II_RELATIONSHIPS CIR ';

2460: -- End changes for bug fix.
2461:
2462: l_sql := l_sql || ' AND ACTIVE_START_DATE <=SYSDATE ';
2463: l_sql := l_sql || ' AND ((ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE>SYSDATE))';
2464: l_sql := l_sql || ' AND NOT EXISTS (SELECT null FROM CSI_II_RELATIONSHIPS CIR ';
2465: l_sql := l_sql || ' WHERE CIR.SUBJECT_ID = CII.INSTANCE_ID ';
2466: l_sql := l_sql || ' AND CIR.RELATIONSHIP_TYPE_CODE = ''COMPONENT-OF''';
2467: l_sql := l_sql || ' AND ((CIR.ACTIVE_START_DATE IS NULL) OR (CIR.ACTIVE_START_DATE <= SYSDATE))';
2468: l_sql := l_sql || ' AND ((CIR.ACTIVE_END_DATE IS NULL) OR (CIR.ACTIVE_END_DATE > SYSDATE)) )';

Line 4367: AND NOT EXISTS (SELECT 'X' FROM CSI_II_RELATIONSHIPS CIR

4363: AND ((CII.ACTIVE_END_DATE IS NULL) OR (CII.ACTIVE_END_DATE > SYSDATE))
4364: AND CII.QUANTITY > 0
4365: AND CII.LOCATION_TYPE_CODE = 'WIP'
4366: AND CII.WIP_JOB_ID = p_wip_entity_id
4367: AND NOT EXISTS (SELECT 'X' FROM CSI_II_RELATIONSHIPS CIR
4368: WHERE CIR.SUBJECT_ID = CII.INSTANCE_ID
4369: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
4370: AND NVL(CIR.ACTIVE_START_DATE,SYSDATE) <= SYSDATE AND
4371: (CIR.ACTIVE_END_DATE IS NULL OR CIR.ACTIVE_END_DATE > SYSDATE));

Line 4802: AND NOT EXISTS (SELECT 'X' FROM CSI_II_RELATIONSHIPS CIR

4798: AND ((ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE > SYSDATE))
4799: AND QUANTITY > 0
4800: AND LOCATION_TYPE_CODE = 'WIP'
4801: AND WIP_JOB_ID = p_wip_entity_id
4802: AND NOT EXISTS (SELECT 'X' FROM CSI_II_RELATIONSHIPS CIR
4803: WHERE CIR.SUBJECT_ID = CII.INSTANCE_ID
4804: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
4805: AND SYSDATE BETWEEN NVL(ACTIVE_START_DATE,SYSDATE) AND NVL(ACTIVE_END_DATE,SYSDATE));
4806:

Line 5110: AND NOT EXISTS (SELECT 'X' FROM CSI_II_RELATIONSHIPS CIR

5106: AND UPPER(NVL(W.INCIDENT_NUMBER,'x')) LIKE UPPER(NVL(p_incident_number,NVL(W.INCIDENT_NUMBER,'x')))
5107: AND NVL(W.PRIORITY,0) = NVL(p_priority,NVL(W.PRIORITY,0))
5108: AND W.VISIT_NUMBER = NVL(p_visit_number,W.VISIT_NUMBER)
5109: AND UPPER(W.JOB_NUMBER) LIKE UPPER(NVL(p_job_number,W.job_number))
5110: AND NOT EXISTS (SELECT 'X' FROM CSI_II_RELATIONSHIPS CIR
5111: WHERE CIR.SUBJECT_ID = CSI.INSTANCE_Id
5112: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
5113: AND SYSDATE BETWEEN NVL(ACTIVE_START_DATE,SYSDATE)
5114: AND NVL(ACTIVE_END_DATE,SYSDATE))