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_B

Line 826: FROM MTL_SYSTEM_ITEMS_B MSIB

822: WHERE UAI.DATA_SET_ID = p_data_set_id
823: AND UAI.PROCESS_STATUS IN (G_PS_IN_PROCESS, G_PS_STYLE_VARIANT_IN_PROCESS)
824: AND UAI.INVENTORY_ITEM_ID IS NOT NULL
825: AND NOT EXISTS (SELECT 'X'
826: FROM MTL_SYSTEM_ITEMS_B MSIB
827: WHERE MSIB.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
828: AND MSIB.ORGANIZATION_ID = UAI.ORGANIZATION_ID);
829: ELSE
830: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI

Line 836: FROM MTL_SYSTEM_ITEMS_B MSIB

832: WHERE UAI.DATA_SET_ID = p_data_set_id
833: AND UAI.PROCESS_STATUS = G_PS_IN_PROCESS
834: AND UAI.INVENTORY_ITEM_ID IS NOT NULL
835: AND NOT EXISTS (SELECT 'X'
836: FROM MTL_SYSTEM_ITEMS_B MSIB
837: WHERE MSIB.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
838: AND MSIB.ORGANIZATION_ID = UAI.ORGANIZATION_ID
839: UNION ALL
840: SELECT 'X'

Line 860: FROM MTL_SYSTEM_ITEMS_B_KFV

856: IF p_validate_only = FND_API.G_FALSE THEN
857: UPDATE EGO_ITM_USR_ATTR_INTRFC intrfc
858: SET INVENTORY_ITEM_ID =
859: (SELECT INVENTORY_ITEM_ID
860: FROM MTL_SYSTEM_ITEMS_B_KFV
861: WHERE CONCATENATED_SEGMENTS = intrfc.ITEM_NUMBER
862: AND ORGANIZATION_ID = intrfc.ORGANIZATION_ID)
863: WHERE DATA_SET_ID = p_data_set_id
864: AND PROCESS_STATUS = G_PS_IN_PROCESS

Line 871: FROM MTL_SYSTEM_ITEMS_B_KFV

867: ELSE
868: UPDATE EGO_ITM_USR_ATTR_INTRFC intrfc
869: SET INVENTORY_ITEM_ID =
870: NVL( (SELECT INVENTORY_ITEM_ID
871: FROM MTL_SYSTEM_ITEMS_B_KFV
872: WHERE CONCATENATED_SEGMENTS = intrfc.ITEM_NUMBER
873: AND ORGANIZATION_ID = intrfc.ORGANIZATION_ID
874: ),
875: (SELECT INVENTORY_ITEM_ID

Line 1044: FROM MTL_SYSTEM_ITEMS_B MSI

1040: SET (UAI.ITEM_CATALOG_GROUP_ID, UAI.PROG_INT_CHAR1,
1041: UAI.PROG_INT_NUM2, UAI.PROG_INT_NUM3)
1042: = (SELECT NVL(MSI.ITEM_CATALOG_GROUP_ID,-1), NVL(MSI.APPROVAL_STATUS,'A'),
1043: MSI.LIFECYCLE_ID, MSI.CURRENT_PHASE_ID
1044: FROM MTL_SYSTEM_ITEMS_B MSI
1045: WHERE MSI.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1046: AND MSI.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1047: ),
1048: PROG_INT_CHAR2 =

Line 1061: FROM MTL_SYSTEM_ITEMS_B MSI

1057: ),PROG_INT_CHAR2)
1058: WHERE UAI.DATA_SET_ID = p_data_set_id
1059: AND PROCESS_STATUS = G_PS_IN_PROCESS
1060: AND EXISTS (SELECT MSI.ITEM_CATALOG_GROUP_ID
1061: FROM MTL_SYSTEM_ITEMS_B MSI
1062: WHERE MSI.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1063: AND MSI.ORGANIZATION_ID = UAI.ORGANIZATION_ID);
1064: ELSE
1065: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI

Line 1070: FROM MTL_SYSTEM_ITEMS_B MSI

1066: SET (UAI.ITEM_CATALOG_GROUP_ID, UAI.PROG_INT_CHAR1,
1067: UAI.PROG_INT_NUM2, UAI.PROG_INT_NUM3)
1068: = (SELECT NVL(MSI.ITEM_CATALOG_GROUP_ID,-1), NVL(MSI.APPROVAL_STATUS,'A'),
1069: MSI.LIFECYCLE_ID, MSI.CURRENT_PHASE_ID
1070: FROM MTL_SYSTEM_ITEMS_B MSI
1071: WHERE MSI.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1072: AND MSI.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1073: ),
1074: PROG_INT_CHAR2 =

Line 1087: FROM MTL_SYSTEM_ITEMS_B MSI

1083: ),PROG_INT_CHAR2)
1084: WHERE UAI.DATA_SET_ID = p_data_set_id
1085: AND PROCESS_STATUS = G_PS_IN_PROCESS
1086: AND EXISTS (SELECT MSI.ITEM_CATALOG_GROUP_ID
1087: FROM MTL_SYSTEM_ITEMS_B MSI
1088: WHERE MSI.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1089: AND MSI.ORGANIZATION_ID = UAI.ORGANIZATION_ID);
1090:
1091: -- If item is not found in production then get the values from interface

Line 1611: MTL_SYSTEM_ITEMS_B msib

1607: AND ROW_IDENTIFIER IN (SELECT ROW_IDENTIFIER
1608: FROM
1609: EGO_ITM_USR_ATTR_INTRFC intf,
1610: EGO_FND_DSC_FLX_CTX_EXT ag_ext,
1611: MTL_SYSTEM_ITEMS_B msib
1612: WHERE intf.DATA_SET_ID = p_data_set_id
1613: AND intf.PROCESS_STATUS = G_PS_IN_PROCESS
1614: AND intf.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
1615: AND ag_ext.VARIANT = 'Y'

Line 1654: SELECT NULL FROM MTL_SYSTEM_ITEMS_B msib

1650: AND msii.INVENTORY_ITEM_ID = intf.INVENTORY_ITEM_ID
1651: AND msii.ORGANIZATION_ID = intf.ORGANIZATION_ID
1652: AND msii.STYLE_ITEM_FLAG = 'N'
1653: UNION ALL
1654: SELECT NULL FROM MTL_SYSTEM_ITEMS_B msib
1655: WHERE intf.INVENTORY_ITEM_ID = msib.INVENTORY_ITEM_ID
1656: AND intf.ORGANIZATION_ID = msib.ORGANIZATION_ID
1657: AND msib.STYLE_ITEM_FLAG = 'N'
1658: )

Line 1826: FROM EGO_FND_DSC_FLX_CTX_EXT AG_EXT1, MTL_SYSTEM_ITEMS_B MSIB

1822: AND MSII.STYLE_ITEM_FLAG = 'Y'
1823: AND INTF.INVENTORY_ITEM_ID = MSII.INVENTORY_ITEM_ID
1824: UNION ALL
1825: SELECT NULL
1826: FROM EGO_FND_DSC_FLX_CTX_EXT AG_EXT1, MTL_SYSTEM_ITEMS_B MSIB
1827: WHERE AG_EXT1.VARIANT = 'Y'
1828: AND AG_EXT1.DESCRIPTIVE_FLEXFIELD_NAME = NVL(INTF.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
1829: AND AG_EXT1.DESCRIPTIVE_FLEX_CONTEXT_CODE = INTF.ATTR_GROUP_INT_NAME
1830: AND INTF.ORGANIZATION_ID = MSIB.ORGANIZATION_ID

Line 1912: MTL_SYSTEM_ITEMS_B MSIB

1908: FROM
1909: EGO_ITM_USR_ATTR_INTRFC INTF,
1910: EGO_FND_DF_COL_USGS_EXT ATTR,
1911: FND_DESCR_FLEX_COLUMN_USAGES FL_COL,
1912: MTL_SYSTEM_ITEMS_B MSIB
1913: WHERE INTF.ATTR_GROUP_TYPE = ATTR.DESCRIPTIVE_FLEXFIELD_NAME
1914: AND INTF.ATTR_GROUP_INT_NAME = ATTR.DESCRIPTIVE_FLEX_CONTEXT_CODE
1915: AND ATTR.APPLICATION_ID = 431
1916: AND ATTR.APPLICATION_ID = FL_COL.APPLICATION_ID