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.EGO_ITEM_AML_PVT dependencies on DUAL

Line 1688: FROM DUAL)

1684: UPDATE ego_aml_intf intf
1685: SET attribute1 =
1686: (SELECT CASE WHEN l_dff_fields_used.attribute1 = FND_API.G_TRUE
1687: THEN intf.attribute1 ELSE NULL END
1688: FROM DUAL)
1689: ,attribute2 =
1690: (SELECT CASE WHEN l_dff_fields_used.attribute2 = FND_API.G_TRUE
1691: THEN intf.attribute2 ELSE NULL END
1692: FROM DUAL)

Line 1692: FROM DUAL)

1688: FROM DUAL)
1689: ,attribute2 =
1690: (SELECT CASE WHEN l_dff_fields_used.attribute2 = FND_API.G_TRUE
1691: THEN intf.attribute2 ELSE NULL END
1692: FROM DUAL)
1693: ,attribute3 =
1694: (SELECT CASE WHEN l_dff_fields_used.attribute3 = FND_API.G_TRUE
1695: THEN intf.attribute3 ELSE NULL END
1696: FROM DUAL)

Line 1696: FROM DUAL)

1692: FROM DUAL)
1693: ,attribute3 =
1694: (SELECT CASE WHEN l_dff_fields_used.attribute3 = FND_API.G_TRUE
1695: THEN intf.attribute3 ELSE NULL END
1696: FROM DUAL)
1697: ,attribute4 =
1698: (SELECT CASE WHEN l_dff_fields_used.attribute4 = FND_API.G_TRUE
1699: THEN intf.attribute4 ELSE NULL END
1700: FROM DUAL)

Line 1700: FROM DUAL)

1696: FROM DUAL)
1697: ,attribute4 =
1698: (SELECT CASE WHEN l_dff_fields_used.attribute4 = FND_API.G_TRUE
1699: THEN intf.attribute4 ELSE NULL END
1700: FROM DUAL)
1701: ,attribute5 =
1702: (SELECT CASE WHEN l_dff_fields_used.attribute5 = FND_API.G_TRUE
1703: THEN intf.attribute5 ELSE NULL END
1704: FROM DUAL)

Line 1704: FROM DUAL)

1700: FROM DUAL)
1701: ,attribute5 =
1702: (SELECT CASE WHEN l_dff_fields_used.attribute5 = FND_API.G_TRUE
1703: THEN intf.attribute5 ELSE NULL END
1704: FROM DUAL)
1705: ,attribute6 =
1706: (SELECT CASE WHEN l_dff_fields_used.attribute6 = FND_API.G_TRUE
1707: THEN intf.attribute6 ELSE NULL END
1708: FROM DUAL)

Line 1708: FROM DUAL)

1704: FROM DUAL)
1705: ,attribute6 =
1706: (SELECT CASE WHEN l_dff_fields_used.attribute6 = FND_API.G_TRUE
1707: THEN intf.attribute6 ELSE NULL END
1708: FROM DUAL)
1709: ,attribute7 =
1710: (SELECT CASE WHEN l_dff_fields_used.attribute7 = FND_API.G_TRUE
1711: THEN intf.attribute7 ELSE NULL END
1712: FROM DUAL)

Line 1712: FROM DUAL)

1708: FROM DUAL)
1709: ,attribute7 =
1710: (SELECT CASE WHEN l_dff_fields_used.attribute7 = FND_API.G_TRUE
1711: THEN intf.attribute7 ELSE NULL END
1712: FROM DUAL)
1713: ,attribute8 =
1714: (SELECT CASE WHEN l_dff_fields_used.attribute8 = FND_API.G_TRUE
1715: THEN intf.attribute8 ELSE NULL END
1716: FROM DUAL)

Line 1716: FROM DUAL)

1712: FROM DUAL)
1713: ,attribute8 =
1714: (SELECT CASE WHEN l_dff_fields_used.attribute8 = FND_API.G_TRUE
1715: THEN intf.attribute8 ELSE NULL END
1716: FROM DUAL)
1717: ,attribute9 =
1718: (SELECT CASE WHEN l_dff_fields_used.attribute9 = FND_API.G_TRUE
1719: THEN intf.attribute9 ELSE NULL END
1720: FROM DUAL)

Line 1720: FROM DUAL)

1716: FROM DUAL)
1717: ,attribute9 =
1718: (SELECT CASE WHEN l_dff_fields_used.attribute9 = FND_API.G_TRUE
1719: THEN intf.attribute9 ELSE NULL END
1720: FROM DUAL)
1721: ,attribute10 =
1722: (SELECT CASE WHEN l_dff_fields_used.attribute10 = FND_API.G_TRUE
1723: THEN intf.attribute10 ELSE NULL END
1724: FROM DUAL)

Line 1724: FROM DUAL)

1720: FROM DUAL)
1721: ,attribute10 =
1722: (SELECT CASE WHEN l_dff_fields_used.attribute10 = FND_API.G_TRUE
1723: THEN intf.attribute10 ELSE NULL END
1724: FROM DUAL)
1725: ,attribute11 =
1726: (SELECT CASE WHEN l_dff_fields_used.attribute11 = FND_API.G_TRUE
1727: THEN intf.attribute11 ELSE NULL END
1728: FROM DUAL)

Line 1728: FROM DUAL)

1724: FROM DUAL)
1725: ,attribute11 =
1726: (SELECT CASE WHEN l_dff_fields_used.attribute11 = FND_API.G_TRUE
1727: THEN intf.attribute11 ELSE NULL END
1728: FROM DUAL)
1729: ,attribute12 =
1730: (SELECT CASE WHEN l_dff_fields_used.attribute12 = FND_API.G_TRUE
1731: THEN intf.attribute12 ELSE NULL END
1732: FROM DUAL)

Line 1732: FROM DUAL)

1728: FROM DUAL)
1729: ,attribute12 =
1730: (SELECT CASE WHEN l_dff_fields_used.attribute12 = FND_API.G_TRUE
1731: THEN intf.attribute12 ELSE NULL END
1732: FROM DUAL)
1733: ,attribute13 =
1734: (SELECT CASE WHEN l_dff_fields_used.attribute13 = FND_API.G_TRUE
1735: THEN intf.attribute13 ELSE NULL END
1736: FROM DUAL)

Line 1736: FROM DUAL)

1732: FROM DUAL)
1733: ,attribute13 =
1734: (SELECT CASE WHEN l_dff_fields_used.attribute13 = FND_API.G_TRUE
1735: THEN intf.attribute13 ELSE NULL END
1736: FROM DUAL)
1737: ,attribute14 =
1738: (SELECT CASE WHEN l_dff_fields_used.attribute14 = FND_API.G_TRUE
1739: THEN intf.attribute14 ELSE NULL END
1740: FROM DUAL)

Line 1740: FROM DUAL)

1736: FROM DUAL)
1737: ,attribute14 =
1738: (SELECT CASE WHEN l_dff_fields_used.attribute14 = FND_API.G_TRUE
1739: THEN intf.attribute14 ELSE NULL END
1740: FROM DUAL)
1741: ,attribute15 =
1742: (SELECT CASE WHEN l_dff_fields_used.attribute15 = FND_API.G_TRUE
1743: THEN intf.attribute15 ELSE NULL END
1744: FROM DUAL)

Line 1744: FROM DUAL)

1740: FROM DUAL)
1741: ,attribute15 =
1742: (SELECT CASE WHEN l_dff_fields_used.attribute15 = FND_API.G_TRUE
1743: THEN intf.attribute15 ELSE NULL END
1744: FROM DUAL)
1745: WHERE CURRENT OF c_item_records;
1746: END IF;
1747: END LOOP;
1748: ELSE

Line 2617: FROM DUAL),

2613: )
2614: THEN EGO_ITEM_PUB.G_INTF_NULL_CHAR
2615: ELSE first_article_status
2616: END
2617: FROM DUAL),
2618: approval_status =
2619: (SELECT CASE WHEN
2620: (approval_status_meaning = EGO_ITEM_PUB.G_INTF_NULL_CHAR
2621: AND

Line 2627: FROM DUAL),

2623: )
2624: THEN EGO_ITEM_PUB.G_INTF_NULL_CHAR
2625: ELSE approval_status
2626: END
2627: FROM DUAL),
2628: request_id = G_REQUEST_ID,
2629: program_application_id = G_PROG_APPID,
2630: program_id = G_PROG_ID,
2631: program_update_date = SYSDATE,