DBA Data[Home] [Help]

APPS.INVPPROC dependencies on MTL_ITEM_REVISIONS_TL

Line 1353: INSERT INTO MTL_ITEM_REVISIONS_TL (

1349: AND r.set_process_id = xset_id
1350: AND r.transaction_type = l_transaction_type;
1351:
1352:
1353: INSERT INTO MTL_ITEM_REVISIONS_TL (
1354: INVENTORY_ITEM_ID,
1355: ORGANIZATION_ID,
1356: REVISION_ID,
1357: DESCRIPTION,

Line 1384: FROM MTL_ITEM_REVISIONS_TL T

1380: AND r.transaction_type = l_transaction_type
1381: and L.INSTALLED_FLAG in ('I', 'B');
1382: /* Bug: 4667452 Removing the following condition
1383: AND NOT EXISTS (SELECT NULL
1384: FROM MTL_ITEM_REVISIONS_TL T
1385: WHERE T.INVENTORY_ITEM_ID = r.INVENTORY_ITEM_ID
1386: AND T.ORGANIZATION_ID = r.ORGANIZATION_ID
1387: AND T.REVISION_ID = r.REVISION_ID
1388: AND T.LANGUAGE = L.LANGUAGE_CODE);