APPS.INVPPROC dependencies on MTL_SYSTEM_ITEMS_TL

Line 1149: INSERT INTO MTL_SYSTEM_ITEMS_TL

1145: -- R11.5 MLS
1146: -- bug 10373720, set last_update date and creation date to sysdate
1147: --- old NVL(I.LAST_UPDATE_DATE, l_sysdate),NVL(I.CREATION_DATE, l_sysdate),
1148:
1149: INSERT INTO MTL_SYSTEM_ITEMS_TL
1150: (
1151: INVENTORY_ITEM_ID,
1152: ORGANIZATION_ID,
1153: LANGUAGE,

Line 1191: from MTL_SYSTEM_ITEMS_TL T

1187:
1188: /*Bug: 4667452 Commneting out the following condition
1189: and not exists
1190: ( select NULL
1191: from MTL_SYSTEM_ITEMS_TL T
1192: where T.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
1193: and T.ORGANIZATION_ID = I.ORGANIZATION_ID
1194: and T.LANGUAGE = L.LANGUAGE_CODE
1195: );

Line 1202: INSERT INTO MTL_SYSTEM_ITEMS_TL

1198: /*Bug 5398775 Create for child org with translations*/
1199: -- bug 10373720, set last_update date and creation date to sysdate
1200: --- old NVL(I.LAST_UPDATE_DATE, l_sysdate),NVL(I.CREATION_DATE, l_sysdate),
1201:
1202: INSERT INTO MTL_SYSTEM_ITEMS_TL
1203: (
1204: INVENTORY_ITEM_ID,
1205: ORGANIZATION_ID,
1206: LANGUAGE,

Line 1229: , MTL_SYSTEM_ITEMS_TL msitl

1225: l_sysdate,
1226: user_id, --* created_by
1227: login_id --* last_update_login
1228: from MTL_SYSTEM_ITEMS_INTERFACE I
1229: , MTL_SYSTEM_ITEMS_TL msitl
1230: , FND_LANGUAGES L
1231: where I.process_flag = l_process_flag_4
1232: and I.set_process_id = xset_id
1233: and I.transaction_type = l_transaction_type

Line 1245: UPDATE MTL_SYSTEM_ITEMS_TL

1241: FROM Mtl_Parameters
1242: WHERE Master_Organization_Id <> Organization_Id);
1243:
1244: FOR cr IN c_ego_intf_rows LOOP
1245: UPDATE MTL_SYSTEM_ITEMS_TL
1246: SET DESCRIPTION = NVL(cr.column_value, DESCRIPTION),
1247: LAST_UPDATE_DATE = l_sysdate,
1248: LAST_UPDATED_BY = user_id,
1249: LAST_UPDATE_LOGIN = login_id