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 841: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII

837: WHERE MSIB.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
838: AND MSIB.ORGANIZATION_ID = UAI.ORGANIZATION_ID
839: UNION ALL
840: SELECT 'X'
841: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII
842: WHERE MSII.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
843: AND MSII.ORGANIZATION_ID = UAI.ORGANIZATION_ID
844: AND MSII.SET_PROCESS_ID = UAI.DATA_SET_ID
845: AND MSII.PROCESS_FLAG = 1

Line 876: FROM MTL_SYSTEM_ITEMS_INTERFACE msii

872: WHERE CONCATENATED_SEGMENTS = intrfc.ITEM_NUMBER
873: AND ORGANIZATION_ID = intrfc.ORGANIZATION_ID
874: ),
875: (SELECT INVENTORY_ITEM_ID
876: FROM MTL_SYSTEM_ITEMS_INTERFACE msii
877: WHERE msii.SET_PROCESS_ID = intrfc.DATA_SET_ID
878: AND msii.PROCESS_FLAG = 1
879: AND (msii.ITEM_NUMBER = intrfc.ITEM_NUMBER OR msii.SOURCE_SYSTEM_REFERENCE = intrfc.SOURCE_SYSTEM_REFERENCE)
880: AND msii.ORGANIZATION_ID = intrfc.ORGANIZATION_ID

Line 1050: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII

1046: AND MSI.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1047: ),
1048: PROG_INT_CHAR2 =
1049: NVL((SELECT 'Y'
1050: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII
1051: WHERE MSII.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1052: AND MSII.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1053: AND MSII.REQUEST_ID = UAI.REQUEST_ID
1054: AND MSII.TRANSACTION_TYPE = 'CREATE'

Line 1076: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII

1072: AND MSI.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1073: ),
1074: PROG_INT_CHAR2 =
1075: NVL((SELECT 'Y'
1076: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII
1077: WHERE MSII.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1078: AND MSII.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1079: AND MSII.TRANSACTION_TYPE = 'CREATE'
1080: AND MSII.PROCESS_FLAG = 1

Line 1099: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII

1095: = (SELECT
1096: NVL( NVL(UAI.ITEM_CATALOG_GROUP_ID, MSII.ITEM_CATALOG_GROUP_ID), -1),
1097: NVL( UAI.PROG_INT_NUM2, MSII.LIFECYCLE_ID),
1098: NVL( UAI.PROG_INT_NUM3, MSII.CURRENT_PHASE_ID)
1099: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII
1100: WHERE MSII.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1101: AND MSII.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1102: AND MSII.SET_PROCESS_ID = UAI.DATA_SET_ID
1103: AND MSII.PROCESS_FLAG = 1

Line 1108: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII

1104: AND ROWNUM = 1
1105: ),
1106: PROG_INT_CHAR2 =
1107: NVL((SELECT 'Y'
1108: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII
1109: WHERE MSII.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1110: AND MSII.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1111: AND MSII.TRANSACTION_TYPE = 'CREATE'
1112: AND MSII.PROCESS_FLAG = 1

Line 1119: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII2

1115: ),PROG_INT_CHAR2)
1116: WHERE UAI.DATA_SET_ID = p_data_set_id
1117: AND PROCESS_STATUS = G_PS_IN_PROCESS
1118: AND EXISTS (SELECT 'X'
1119: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII2
1120: WHERE MSII2.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1121: AND MSII2.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1122: AND MSII2.SET_PROCESS_ID = UAI.DATA_SET_ID
1123: AND MSII2.PROCESS_FLAG = 1

Line 1647: AND EXISTS (SELECT NULL FROM MTL_SYSTEM_ITEMS_INTERFACE msii

1643: AND intf.PROCESS_STATUS = G_PS_IN_PROCESS
1644: AND intf.ATTR_GROUP_ID = eagd.ATTR_GROUP_ID
1645: AND intf.DATA_LEVEL_ID = eagd.DATA_LEVEL_ID
1646: AND NVL(eagd.DEFAULTING, 'D') = 'I'
1647: AND EXISTS (SELECT NULL FROM MTL_SYSTEM_ITEMS_INTERFACE msii
1648: WHERE msii.SET_PROCESS_ID = intf.DATA_SET_ID
1649: AND msii.PROCESS_FLAG = 1
1650: AND msii.INVENTORY_ITEM_ID = intf.INVENTORY_ITEM_ID
1651: AND msii.ORGANIZATION_ID = intf.ORGANIZATION_ID

Line 1817: FROM EGO_FND_DSC_FLX_CTX_EXT AG_EXT, MTL_SYSTEM_ITEMS_INTERFACE MSII

1813: SET PROCESS_STATUS = G_PS_STYLE_VARIANT_IN_PROCESS
1814: WHERE INTF.DATA_SET_ID = p_data_set_id
1815: AND INTF.PROCESS_STATUS = G_PS_IN_PROCESS
1816: AND EXISTS (SELECT NULL
1817: FROM EGO_FND_DSC_FLX_CTX_EXT AG_EXT, MTL_SYSTEM_ITEMS_INTERFACE MSII
1818: WHERE AG_EXT.VARIANT = 'Y'
1819: AND AG_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL(INTF.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
1820: AND AG_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = INTF.ATTR_GROUP_INT_NAME
1821: AND INTF.ORGANIZATION_ID = MSII.ORGANIZATION_ID

Line 2436: MTL_SYSTEM_ITEMS_INTERFACE MSII

2432: EGO_ITM_USR_ATTR_INTRFC INTF,
2433: EGO_STYLE_VARIANT_ATTR_VS SVA,
2434: EGO_FND_DF_COL_USGS_EXT ATTR,
2435: FND_DESCR_FLEX_COLUMN_USAGES FL_COL,
2436: MTL_SYSTEM_ITEMS_INTERFACE MSII
2437: WHERE INTF.DATA_SET_ID = p_data_set_id
2438: AND INTF.PROCESS_STATUS = G_PS_IN_PROCESS
2439: AND INTF.ATTR_GROUP_TYPE = ATTR.DESCRIPTIVE_FLEXFIELD_NAME
2440: AND INTF.ATTR_GROUP_INT_NAME = ATTR.DESCRIPTIVE_FLEX_CONTEXT_CODE