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 1132: FROM MTL_ITEM_REVISIONS_INTERFACE miri

1128: AND MIR.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1129: AND MIR.REVISION_ID = UAI.REVISION_ID
1130: UNION ALL
1131: SELECT 'X'
1132: FROM MTL_ITEM_REVISIONS_INTERFACE miri
1133: WHERE miri.SET_PROCESS_ID = UAI.DATA_SET_ID
1134: AND miri.PROCESS_FLAG = 1
1135: AND miri.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1136: AND miri.ORGANIZATION_ID = UAI.ORGANIZATION_ID

Line 1171: FROM MTL_ITEM_REVISIONS_INTERFACE miri

1167: AND MIR.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1168: AND MIR.REVISION = UAI.REVISION
1169: ),
1170: (SELECT miri.REVISION_ID
1171: FROM MTL_ITEM_REVISIONS_INTERFACE miri
1172: WHERE miri.SET_PROCESS_ID = UAI.DATA_SET_ID
1173: AND miri.PROCESS_FLAG = 1
1174: AND miri.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1175: AND miri.ORGANIZATION_ID = UAI.ORGANIZATION_ID

Line 1191: FROM MTL_ITEM_REVISIONS_INTERFACE miri

1187: AND MIR2.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1188: AND MIR2.REVISION = UAI.REVISION
1189: UNION ALL
1190: SELECT 'X'
1191: FROM MTL_ITEM_REVISIONS_INTERFACE miri
1192: WHERE miri.SET_PROCESS_ID = UAI.DATA_SET_ID
1193: AND miri.PROCESS_FLAG = 1
1194: AND miri.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1195: AND miri.ORGANIZATION_ID = UAI.ORGANIZATION_ID

Line 2106: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

2102: WHERE MIR.REVISION_ID = UAI.REVISION_ID
2103: ), UAI.PROG_INT_NUM3),
2104: PROG_INT_CHAR2 =
2105: NVL((SELECT 'Y'
2106: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
2107: WHERE MIRI.REVISION_ID = UAI.REVISION_ID
2108: AND MIRI.request_id = UAI.REQUEST_ID
2109: AND MIRI.TRANSACTION_TYPE = 'CREATE'
2110: AND MIRI.PROCESS_FLAG = 7

Line 2129: FROM MTL_ITEM_REVISIONS_INTERFACE miri

2125: FROM MTL_ITEM_REVISIONS mir1
2126: WHERE mir1.REVISION_ID = UAI.REVISION_ID
2127: )
2128: ELSE (SELECT miri.CURRENT_PHASE_ID
2129: FROM MTL_ITEM_REVISIONS_INTERFACE miri
2130: WHERE miri.REVISION_ID = UAI.REVISION_ID
2131: AND miri.SET_PROCESS_ID = UAI.DATA_SET_ID
2132: AND miri.PROCESS_FLAG = 1
2133: AND ROWNUM = 1

Line 2139: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI1

2135: END
2136: ), UAI.PROG_INT_NUM3),
2137: PROG_INT_CHAR2 =
2138: NVL((SELECT 'Y'
2139: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI1
2140: WHERE MIRI1.REVISION_ID = UAI.REVISION_ID
2141: AND MIRI1.SET_PROCESS_ID = UAI.DATA_SET_ID
2142: AND MIRI1.TRANSACTION_TYPE = 'CREATE'
2143: AND MIRI1.PROCESS_FLAG = 1