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_USER_ATTRS_CP_PUB dependencies on MTL_ITEM_REVISIONS_INTERFACE

Line 943: FROM MTL_ITEM_REVISIONS_INTERFACE miri

939: AND MIR.ORGANIZATION_ID = UAI.ORGANIZATION_ID
940: AND MIR.REVISION_ID = UAI.REVISION_ID
941: UNION ALL
942: SELECT 'X'
943: FROM MTL_ITEM_REVISIONS_INTERFACE miri
944: WHERE miri.SET_PROCESS_ID = UAI.DATA_SET_ID
945: AND miri.PROCESS_FLAG = 1
946: AND miri.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
947: AND miri.ORGANIZATION_ID = UAI.ORGANIZATION_ID

Line 982: FROM MTL_ITEM_REVISIONS_INTERFACE miri

978: AND MIR.ORGANIZATION_ID = UAI.ORGANIZATION_ID
979: AND MIR.REVISION = UAI.REVISION
980: ),
981: (SELECT miri.REVISION_ID
982: FROM MTL_ITEM_REVISIONS_INTERFACE miri
983: WHERE miri.SET_PROCESS_ID = UAI.DATA_SET_ID
984: AND miri.PROCESS_FLAG = 1
985: AND miri.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
986: AND miri.ORGANIZATION_ID = UAI.ORGANIZATION_ID

Line 1002: FROM MTL_ITEM_REVISIONS_INTERFACE miri

998: AND MIR2.ORGANIZATION_ID = UAI.ORGANIZATION_ID
999: AND MIR2.REVISION = UAI.REVISION
1000: UNION ALL
1001: SELECT 'X'
1002: FROM MTL_ITEM_REVISIONS_INTERFACE miri
1003: WHERE miri.SET_PROCESS_ID = UAI.DATA_SET_ID
1004: AND miri.PROCESS_FLAG = 1
1005: AND miri.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1006: AND miri.ORGANIZATION_ID = UAI.ORGANIZATION_ID

Line 1676: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

1672: WHERE MIR.REVISION_ID = UAI.REVISION_ID
1673: ), UAI.PROG_INT_NUM3),
1674: PROG_INT_CHAR2 =
1675: NVL((SELECT 'Y'
1676: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
1677: WHERE MIRI.REVISION_ID = UAI.REVISION_ID
1678: AND MIRI.request_id = UAI.REQUEST_ID
1679: AND MIRI.TRANSACTION_TYPE = 'CREATE'
1680: AND MIRI.PROCESS_FLAG = 7

Line 1699: FROM MTL_ITEM_REVISIONS_INTERFACE miri

1695: FROM MTL_ITEM_REVISIONS mir1
1696: WHERE mir1.REVISION_ID = UAI.REVISION_ID
1697: )
1698: ELSE (SELECT miri.CURRENT_PHASE_ID
1699: FROM MTL_ITEM_REVISIONS_INTERFACE miri
1700: WHERE miri.REVISION_ID = UAI.REVISION_ID
1701: AND miri.SET_PROCESS_ID = UAI.DATA_SET_ID
1702: AND miri.PROCESS_FLAG = 1
1703: AND ROWNUM = 1

Line 1709: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI1

1705: END
1706: ), UAI.PROG_INT_NUM3),
1707: PROG_INT_CHAR2 =
1708: NVL((SELECT 'Y'
1709: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI1
1710: WHERE MIRI1.REVISION_ID = UAI.REVISION_ID
1711: AND MIRI1.SET_PROCESS_ID = UAI.DATA_SET_ID
1712: AND MIRI1.TRANSACTION_TYPE = 'CREATE'
1713: AND MIRI1.PROCESS_FLAG = 1