DBA Data[Home] [Help]

APPS.INVPPROC dependencies on MTL_ITEM_REVISIONS_TL

Line 1437: INSERT INTO MTL_ITEM_REVISIONS_TL (

1433: --- bug 10373720
1434: --- updated the WHO columns to reflect current user
1435: --- and timstamp, rather that those in interface tbl
1436: ---
1437: INSERT INTO MTL_ITEM_REVISIONS_TL (
1438: INVENTORY_ITEM_ID,
1439: ORGANIZATION_ID,
1440: REVISION_ID,
1441: DESCRIPTION,

Line 1468: FROM MTL_ITEM_REVISIONS_TL T

1464: AND r.transaction_type = l_transaction_type
1465: and L.INSTALLED_FLAG in ('I', 'B');
1466: /* Bug: 4667452 Removing the following condition
1467: AND NOT EXISTS (SELECT NULL
1468: FROM MTL_ITEM_REVISIONS_TL T
1469: WHERE T.INVENTORY_ITEM_ID = r.INVENTORY_ITEM_ID
1470: AND T.ORGANIZATION_ID = r.ORGANIZATION_ID
1471: AND T.REVISION_ID = r.REVISION_ID
1472: AND T.LANGUAGE = L.LANGUAGE_CODE);