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_SYSTEM_ITEMS_INTERFACE

Line 381: FROM MTL_SYSTEM_ITEMS_INTERFACE msii_e

377: ELSE
378: x_security_predicate := x_security_predicate ||
379: ' AND NOT EXISTS
380: (SELECT 1
381: FROM MTL_SYSTEM_ITEMS_INTERFACE msii_e
382: WHERE msii_e.TRANSACTION_TYPE = ''CREATE''
383: AND msii_e.PROCESS_FLAG = 1
384: AND msii_e.SET_PROCESS_ID = UAI2.DATA_SET_ID
385: AND msii_e.INVENTORY_ITEM_ID = UAI2.INVENTORY_ITEM_ID

Line 999: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII

995: WHERE MSIB.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
996: AND MSIB.ORGANIZATION_ID = UAI.ORGANIZATION_ID
997: UNION ALL
998: SELECT 'X'
999: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII
1000: WHERE MSII.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1001: AND MSII.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1002: AND MSII.SET_PROCESS_ID = UAI.DATA_SET_ID
1003: AND MSII.PROCESS_FLAG = 1

Line 1036: FROM MTL_SYSTEM_ITEMS_INTERFACE msii

1032: WHERE CONCATENATED_SEGMENTS = intrfc.ITEM_NUMBER
1033: AND ORGANIZATION_ID = intrfc.ORGANIZATION_ID
1034: ),
1035: (SELECT INVENTORY_ITEM_ID
1036: FROM MTL_SYSTEM_ITEMS_INTERFACE msii
1037: WHERE msii.SET_PROCESS_ID = intrfc.DATA_SET_ID
1038: AND msii.PROCESS_FLAG = 1
1039: AND (msii.ITEM_NUMBER = intrfc.ITEM_NUMBER OR msii.SOURCE_SYSTEM_REFERENCE = intrfc.SOURCE_SYSTEM_REFERENCE)
1040: AND msii.ORGANIZATION_ID = intrfc.ORGANIZATION_ID

Line 1057: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII

1053: WHERE MSIK.CONCATENATED_SEGMENTS = INTRFC.ITEM_NUMBER
1054: AND MSIK.ORGANIZATION_ID = INTRFC.ORGANIZATION_ID
1055: ),
1056: NVL((SELECT INVENTORY_ITEM_ID
1057: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII
1058: WHERE ( MSII.ITEM_NUMBER = INTRFC.ITEM_NUMBER )
1059: AND MSII.ORGANIZATION_ID = INTRFC.ORGANIZATION_ID
1060: AND MSII.SET_PROCESS_ID = INTRFC.DATA_SET_ID
1061: AND MSII.PROCESS_FLAG = 1

Line 1064: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII

1060: AND MSII.SET_PROCESS_ID = INTRFC.DATA_SET_ID
1061: AND MSII.PROCESS_FLAG = 1
1062: AND ROWNUM = 1),
1063: (SELECT INVENTORY_ITEM_ID
1064: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII
1065: WHERE ( MSII.SOURCE_SYSTEM_REFERENCE = INTRFC.SOURCE_SYSTEM_REFERENCE )
1066: AND MSII.ORGANIZATION_ID = INTRFC.ORGANIZATION_ID
1067: AND MSII.SET_PROCESS_ID = INTRFC.DATA_SET_ID
1068: AND MSII.PROCESS_FLAG = 1

Line 1242: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII

1238: AND MSI.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1239: ),
1240: PROG_INT_CHAR2 =
1241: NVL((SELECT 'Y'
1242: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII
1243: WHERE MSII.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1244: AND MSII.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1245: AND MSII.REQUEST_ID = UAI.REQUEST_ID
1246: AND MSII.TRANSACTION_TYPE = 'CREATE'

Line 1267: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII

1263: = (SELECT
1264: NVL(UAI.ITEM_CATALOG_GROUP_ID, MSII.ITEM_CATALOG_GROUP_ID),
1265: NVL( UAI.PROG_INT_NUM2, MSII.LIFECYCLE_ID),
1266: NVL( UAI.PROG_INT_NUM3, MSII.CURRENT_PHASE_ID)
1267: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII
1268: WHERE MSII.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1269: AND MSII.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1270: AND MSII.SET_PROCESS_ID = UAI.DATA_SET_ID
1271: AND MSII.PROCESS_FLAG = 1

Line 1276: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII

1272: AND ROWNUM = 1
1273: ),
1274: PROG_INT_CHAR2 =
1275: NVL((SELECT 'Y'
1276: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII
1277: WHERE MSII.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1278: AND MSII.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1279: AND MSII.TRANSACTION_TYPE = 'CREATE'
1280: AND MSII.PROCESS_FLAG = 1

Line 1287: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII2

1283: ),PROG_INT_CHAR2)
1284: WHERE UAI.DATA_SET_ID = p_data_set_id
1285: AND PROCESS_STATUS = G_PS_IN_PROCESS
1286: AND EXISTS (SELECT 'X'
1287: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII2
1288: WHERE MSII2.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1289: AND MSII2.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1290: AND MSII2.SET_PROCESS_ID = UAI.DATA_SET_ID
1291: AND MSII2.PROCESS_FLAG = 1

Line 1307: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII

1303: AND MSI.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1304: ),
1305: PROG_INT_CHAR2 =
1306: NVL((SELECT 'Y'
1307: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII
1308: WHERE MSII.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1309: AND MSII.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1310: AND MSII.TRANSACTION_TYPE = 'CREATE'
1311: AND MSII.PROCESS_FLAG = 1

Line 1333: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII

1329: AND MSI.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1330: ),
1331: PROG_INT_CHAR2 =
1332: NVL((SELECT 'Y'
1333: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII
1334: WHERE MSII.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1335: AND MSII.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1336: AND MSII.TRANSACTION_TYPE = 'CREATE'
1337: AND MSII.PROCESS_FLAG = 1

Line 1356: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII

1352: = (SELECT
1353: NVL( NVL(UAI.ITEM_CATALOG_GROUP_ID, MSII.ITEM_CATALOG_GROUP_ID), -1),
1354: NVL( UAI.PROG_INT_NUM2, MSII.LIFECYCLE_ID),
1355: NVL( UAI.PROG_INT_NUM3, MSII.CURRENT_PHASE_ID)
1356: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII
1357: WHERE MSII.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1358: AND MSII.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1359: AND MSII.SET_PROCESS_ID = UAI.DATA_SET_ID
1360: AND MSII.PROCESS_FLAG = 1

Line 1365: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII

1361: AND ROWNUM = 1
1362: ),
1363: PROG_INT_CHAR2 =
1364: NVL((SELECT 'Y'
1365: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII
1366: WHERE MSII.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1367: AND MSII.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1368: AND MSII.TRANSACTION_TYPE = 'CREATE'
1369: AND MSII.PROCESS_FLAG = 1

Line 1376: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII2

1372: ),PROG_INT_CHAR2)
1373: WHERE UAI.DATA_SET_ID = p_data_set_id
1374: AND PROCESS_STATUS = G_PS_IN_PROCESS
1375: AND EXISTS (SELECT 'X'
1376: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII2
1377: WHERE MSII2.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1378: AND MSII2.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1379: AND MSII2.SET_PROCESS_ID = UAI.DATA_SET_ID
1380: AND MSII2.PROCESS_FLAG = 1

Line 2077: AND EXISTS (SELECT NULL FROM MTL_SYSTEM_ITEMS_INTERFACE msii

2073: AND intf.PROCESS_STATUS = G_PS_IN_PROCESS
2074: AND intf.ATTR_GROUP_ID = eagd.ATTR_GROUP_ID
2075: AND intf.DATA_LEVEL_ID = eagd.DATA_LEVEL_ID
2076: AND NVL(eagd.DEFAULTING, 'D') = 'I'
2077: AND EXISTS (SELECT NULL FROM MTL_SYSTEM_ITEMS_INTERFACE msii
2078: WHERE msii.SET_PROCESS_ID = intf.DATA_SET_ID
2079: AND msii.PROCESS_FLAG = 1
2080: AND msii.INVENTORY_ITEM_ID = intf.INVENTORY_ITEM_ID
2081: AND msii.ORGANIZATION_ID = intf.ORGANIZATION_ID

Line 2249: FROM EGO_FND_DSC_FLX_CTX_EXT AG_EXT, MTL_SYSTEM_ITEMS_INTERFACE MSII

2245: SET PROCESS_STATUS = G_PS_STYLE_VARIANT_IN_PROCESS
2246: WHERE INTF.DATA_SET_ID = p_data_set_id
2247: AND INTF.PROCESS_STATUS = G_PS_IN_PROCESS
2248: AND EXISTS (SELECT NULL
2249: FROM EGO_FND_DSC_FLX_CTX_EXT AG_EXT, MTL_SYSTEM_ITEMS_INTERFACE MSII
2250: WHERE AG_EXT.VARIANT = 'Y'
2251: AND AG_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL(INTF.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
2252: AND AG_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = INTF.ATTR_GROUP_INT_NAME
2253: AND INTF.ORGANIZATION_ID = MSII.ORGANIZATION_ID

Line 3088: MTL_SYSTEM_ITEMS_INTERFACE MSII

3084: EGO_ITM_USR_ATTR_INTRFC INTF,
3085: EGO_STYLE_VARIANT_ATTR_VS SVA,
3086: EGO_FND_DF_COL_USGS_EXT ATTR,
3087: FND_DESCR_FLEX_COLUMN_USAGES FL_COL,
3088: MTL_SYSTEM_ITEMS_INTERFACE MSII
3089: WHERE INTF.DATA_SET_ID = p_data_set_id
3090: AND INTF.PROCESS_STATUS = G_PS_IN_PROCESS
3091: AND INTF.ATTR_GROUP_TYPE = ATTR.DESCRIPTIVE_FLEXFIELD_NAME
3092: AND INTF.ATTR_GROUP_INT_NAME = ATTR.DESCRIPTIVE_FLEX_CONTEXT_CODE

Line 3440: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII

3436: AND UAI.PROCESS_STATUS = G_PS_IN_PROCESS
3437: AND EXISTS
3438: (
3439: SELECT 1
3440: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII
3441: WHERE MSII.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
3442: AND MSII.ORGANIZATION_ID = UAI.ORGANIZATION_ID
3443: AND MSII.SET_PROCESS_ID = UAI.DATA_SET_ID
3444: AND MSII.PROCESS_FLAG IN (1, 7)

Line 3457: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII

3453: AND UAI.TRANSACTION_TYPE='SYNC'
3454: AND EXISTS
3455: (
3456: SELECT 1
3457: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII
3458: WHERE MSII.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
3459: AND MSII.ORGANIZATION_ID = UAI.ORGANIZATION_ID
3460: AND MSII.SET_PROCESS_ID = UAI.DATA_SET_ID
3461: AND MSII.PROCESS_FLAG = 1