APPS.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 984: FROM MTL_SYSTEM_ITEMS_B MSIB

980: WHERE UAI.DATA_SET_ID = p_data_set_id
981: AND UAI.PROCESS_STATUS IN (G_PS_IN_PROCESS, G_PS_STYLE_VARIANT_IN_PROCESS)
982: AND UAI.INVENTORY_ITEM_ID IS NOT NULL
983: AND NOT EXISTS (SELECT 'X'
984: FROM MTL_SYSTEM_ITEMS_B MSIB
985: WHERE MSIB.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
986: AND MSIB.ORGANIZATION_ID = UAI.ORGANIZATION_ID);
987: ELSE
988: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI

Line 994: FROM MTL_SYSTEM_ITEMS_B MSIB

990: WHERE UAI.DATA_SET_ID = p_data_set_id
991: AND UAI.PROCESS_STATUS = G_PS_IN_PROCESS
992: AND UAI.INVENTORY_ITEM_ID IS NOT NULL
993: AND NOT EXISTS (SELECT 'X'
994: FROM MTL_SYSTEM_ITEMS_B MSIB
995: WHERE MSIB.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
996: AND MSIB.ORGANIZATION_ID = UAI.ORGANIZATION_ID
997: UNION ALL
998: SELECT 'X'

Line 1018: FROM MTL_SYSTEM_ITEMS_B_KFV

1014: IF p_validate_only = FND_API.G_FALSE THEN
1015: UPDATE EGO_ITM_USR_ATTR_INTRFC intrfc
1016: SET INVENTORY_ITEM_ID =
1017: (SELECT INVENTORY_ITEM_ID
1018: FROM MTL_SYSTEM_ITEMS_B_KFV
1019: WHERE CONCATENATED_SEGMENTS = intrfc.ITEM_NUMBER
1020: AND ORGANIZATION_ID = intrfc.ORGANIZATION_ID)
1021: WHERE DATA_SET_ID = p_data_set_id
1022: AND PROCESS_STATUS = G_PS_IN_PROCESS

Line 1031: FROM MTL_SYSTEM_ITEMS_B_KFV

1027: /*
1028: UPDATE EGO_ITM_USR_ATTR_INTRFC intrfc
1029: SET INVENTORY_ITEM_ID =
1030: NVL( (SELECT INVENTORY_ITEM_ID
1031: FROM MTL_SYSTEM_ITEMS_B_KFV
1032: WHERE CONCATENATED_SEGMENTS = intrfc.ITEM_NUMBER
1033: AND ORGANIZATION_ID = intrfc.ORGANIZATION_ID
1034: ),
1035: (SELECT INVENTORY_ITEM_ID

Line 1236: FROM MTL_SYSTEM_ITEMS_B MSI

1232: SET (UAI.ITEM_CATALOG_GROUP_ID, UAI.PROG_INT_CHAR1,
1233: UAI.PROG_INT_NUM2, UAI.PROG_INT_NUM3)
1234: = (SELECT NVL(MSI.ITEM_CATALOG_GROUP_ID,-1), NVL(MSI.APPROVAL_STATUS,'A'),
1235: MSI.LIFECYCLE_ID, MSI.CURRENT_PHASE_ID
1236: FROM MTL_SYSTEM_ITEMS_B MSI
1237: WHERE MSI.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1238: AND MSI.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1239: ),
1240: PROG_INT_CHAR2 =

Line 1253: FROM MTL_SYSTEM_ITEMS_B MSI

1249: ),PROG_INT_CHAR2)
1250: WHERE UAI.DATA_SET_ID = p_data_set_id
1251: AND PROCESS_STATUS = G_PS_IN_PROCESS
1252: AND EXISTS (SELECT /*+ NO_UNNEST */ MSI.ITEM_CATALOG_GROUP_ID
1253: FROM MTL_SYSTEM_ITEMS_B MSI
1254: WHERE MSI.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1255: AND MSI.ORGANIZATION_ID = UAI.ORGANIZATION_ID);
1256: ELSE
1257: -- Bug 11719885 : Start

Line 1301: FROM MTL_SYSTEM_ITEMS_B MSI

1297: UAI.PROG_INT_NUM2, UAI.PROG_INT_NUM3)
1298: = (SELECT NVL(Nvl(UAI.ITEM_CATALOG_GROUP_ID,MSI.ITEM_CATALOG_GROUP_ID),-1) ,
1299: NVL(MSI.APPROVAL_STATUS,'A'),
1300: MSI.LIFECYCLE_ID, MSI.CURRENT_PHASE_ID
1301: FROM MTL_SYSTEM_ITEMS_B MSI
1302: WHERE MSI.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1303: AND MSI.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1304: ),
1305: PROG_INT_CHAR2 =

Line 1318: FROM MTL_SYSTEM_ITEMS_B MSI

1314: ),PROG_INT_CHAR2)
1315: WHERE UAI.DATA_SET_ID = p_data_set_id
1316: AND PROCESS_STATUS = G_PS_IN_PROCESS
1317: AND EXISTS (SELECT MSI.ITEM_CATALOG_GROUP_ID
1318: FROM MTL_SYSTEM_ITEMS_B MSI
1319: WHERE MSI.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1320: AND MSI.ORGANIZATION_ID = UAI.ORGANIZATION_ID);
1321: /*
1322: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI

Line 1327: FROM MTL_SYSTEM_ITEMS_B MSI

1323: SET (UAI.ITEM_CATALOG_GROUP_ID, UAI.PROG_INT_CHAR1,
1324: UAI.PROG_INT_NUM2, UAI.PROG_INT_NUM3)
1325: = (SELECT MSI.ITEM_CATALOG_GROUP_ID, NVL(MSI.APPROVAL_STATUS,'A'), -- Fix by bug 11782276
1326: MSI.LIFECYCLE_ID, MSI.CURRENT_PHASE_ID
1327: FROM MTL_SYSTEM_ITEMS_B MSI
1328: WHERE MSI.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1329: AND MSI.ORGANIZATION_ID = UAI.ORGANIZATION_ID
1330: ),
1331: PROG_INT_CHAR2 =

Line 1344: FROM MTL_SYSTEM_ITEMS_B MSI

1340: ),PROG_INT_CHAR2)
1341: WHERE UAI.DATA_SET_ID = p_data_set_id
1342: AND PROCESS_STATUS = G_PS_IN_PROCESS
1343: AND EXISTS (SELECT MSI.ITEM_CATALOG_GROUP_ID
1344: FROM MTL_SYSTEM_ITEMS_B MSI
1345: WHERE MSI.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID
1346: AND MSI.ORGANIZATION_ID = UAI.ORGANIZATION_ID);
1347:
1348: -- If item is not found in production then get the values from interface

Line 2041: MTL_SYSTEM_ITEMS_B msib

2037: AND ROW_IDENTIFIER IN (SELECT ROW_IDENTIFIER
2038: FROM
2039: EGO_ITM_USR_ATTR_INTRFC intf,
2040: EGO_FND_DSC_FLX_CTX_EXT ag_ext,
2041: MTL_SYSTEM_ITEMS_B msib
2042: WHERE intf.DATA_SET_ID = p_data_set_id
2043: AND intf.PROCESS_STATUS = G_PS_IN_PROCESS
2044: AND intf.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
2045: AND ag_ext.VARIANT = 'Y'

Line 2084: SELECT NULL FROM MTL_SYSTEM_ITEMS_B msib

2080: AND msii.INVENTORY_ITEM_ID = intf.INVENTORY_ITEM_ID
2081: AND msii.ORGANIZATION_ID = intf.ORGANIZATION_ID
2082: AND msii.STYLE_ITEM_FLAG = 'N'
2083: UNION ALL
2084: SELECT NULL FROM MTL_SYSTEM_ITEMS_B msib
2085: WHERE intf.INVENTORY_ITEM_ID = msib.INVENTORY_ITEM_ID
2086: AND intf.ORGANIZATION_ID = msib.ORGANIZATION_ID
2087: AND msib.STYLE_ITEM_FLAG = 'N'
2088: )

Line 2259: FROM EGO_FND_DSC_FLX_CTX_EXT AG_EXT1, MTL_SYSTEM_ITEMS_B MSIB

2255: AND INTF.INVENTORY_ITEM_ID = MSII.INVENTORY_ITEM_ID
2256: AND AG_EXT.APPLICATION_ID = 431 /* Bug 9678667 */
2257: UNION ALL
2258: SELECT NULL
2259: FROM EGO_FND_DSC_FLX_CTX_EXT AG_EXT1, MTL_SYSTEM_ITEMS_B MSIB
2260: WHERE AG_EXT1.VARIANT = 'Y'
2261: AND AG_EXT1.DESCRIPTIVE_FLEXFIELD_NAME = NVL(INTF.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
2262: AND AG_EXT1.DESCRIPTIVE_FLEX_CONTEXT_CODE = INTF.ATTR_GROUP_INT_NAME
2263: AND INTF.ORGANIZATION_ID = MSIB.ORGANIZATION_ID

Line 2346: MTL_SYSTEM_ITEMS_B MSIB

2342: FROM
2343: EGO_ITM_USR_ATTR_INTRFC INTF,
2344: EGO_FND_DF_COL_USGS_EXT ATTR,
2345: FND_DESCR_FLEX_COLUMN_USAGES FL_COL,
2346: MTL_SYSTEM_ITEMS_B MSIB
2347: WHERE INTF.ATTR_GROUP_TYPE = ATTR.DESCRIPTIVE_FLEXFIELD_NAME
2348: AND INTF.ATTR_GROUP_INT_NAME = ATTR.DESCRIPTIVE_FLEX_CONTEXT_CODE
2349: AND ATTR.APPLICATION_ID = 431
2350: AND ATTR.APPLICATION_ID = FL_COL.APPLICATION_ID