DBA Data[Home] [Help]

APPS.INVPPROC dependencies on MTL_SYSTEM_ITEMS_TL

Line 1078: INSERT INTO MTL_SYSTEM_ITEMS_TL

1074: END IF;
1075:
1076: -- R11.5 MLS
1077:
1078: INSERT INTO MTL_SYSTEM_ITEMS_TL
1079: (
1080: INVENTORY_ITEM_ID,
1081: ORGANIZATION_ID,
1082: LANGUAGE,

Line 1120: from MTL_SYSTEM_ITEMS_TL T

1116:
1117: /*Bug: 4667452 Commneting out the following condition
1118: and not exists
1119: ( select NULL
1120: from MTL_SYSTEM_ITEMS_TL T
1121: where T.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
1122: and T.ORGANIZATION_ID = I.ORGANIZATION_ID
1123: and T.LANGUAGE = L.LANGUAGE_CODE
1124: );

Line 1128: INSERT INTO MTL_SYSTEM_ITEMS_TL

1124: );
1125: End comment Bug: 4667452*/
1126:
1127: /*Bug 5398775 Create for child org with translations*/
1128: INSERT INTO MTL_SYSTEM_ITEMS_TL
1129: (
1130: INVENTORY_ITEM_ID,
1131: ORGANIZATION_ID,
1132: LANGUAGE,

Line 1155: , MTL_SYSTEM_ITEMS_TL msitl

1151: NVL(I.CREATION_DATE, l_sysdate),
1152: user_id, --* created_by
1153: login_id --* last_update_login
1154: from MTL_SYSTEM_ITEMS_INTERFACE I
1155: , MTL_SYSTEM_ITEMS_TL msitl
1156: , FND_LANGUAGES L
1157: where I.process_flag = l_process_flag_4
1158: and I.set_process_id = xset_id
1159: and I.transaction_type = l_transaction_type

Line 1171: UPDATE MTL_SYSTEM_ITEMS_TL

1167: FROM Mtl_Parameters
1168: WHERE Master_Organization_Id <> Organization_Id);
1169:
1170: FOR cr IN c_ego_intf_rows LOOP
1171: UPDATE MTL_SYSTEM_ITEMS_TL
1172: SET DESCRIPTION = NVL(cr.column_value, DESCRIPTION),
1173: LAST_UPDATE_DATE = l_sysdate,
1174: LAST_UPDATED_BY = user_id,
1175: LAST_UPDATE_LOGIN = login_id