DBA Data[Home] [Help]

APPS.INVIDIT2 dependencies on MTL_ITEM_REVISIONS_TL

Line 475: INSERT INTO MTL_ITEM_REVISIONS_TL (

471: 1
472: from mtl_parameters
473: where organization_id = X_org_id;
474:
475: INSERT INTO MTL_ITEM_REVISIONS_TL (
476: INVENTORY_ITEM_ID,
477: ORGANIZATION_ID,
478: REVISION_ID,
479: DESCRIPTION,

Line 501: FROM MTL_ITEM_REVISIONS_TL T

497: USERENV('LANG')
498: FROM FND_LANGUAGES L
499: WHERE L.INSTALLED_FLAG in ('I', 'B')
500: AND NOT EXISTS (SELECT NULL
501: FROM MTL_ITEM_REVISIONS_TL T
502: WHERE T.INVENTORY_ITEM_ID = X_item_id
503: AND T.ORGANIZATION_ID = X_org_id
504: AND T.REVISION_ID = l_revision_id
505: AND T.LANGUAGE = L.LANGUAGE_CODE);

Line 542: INSERT INTO MTL_ITEM_REVISIONS_TL (

538: 1
539: from mtl_parameters
540: where organization_id = X_org_id;
541:
542: INSERT INTO MTL_ITEM_REVISIONS_TL (
543: INVENTORY_ITEM_ID,
544: ORGANIZATION_ID,
545: REVISION_ID,
546: DESCRIPTION,

Line 568: FROM MTL_ITEM_REVISIONS_TL T

564: USERENV('LANG')
565: FROM FND_LANGUAGES L
566: WHERE L.INSTALLED_FLAG in ('I', 'B')
567: AND NOT EXISTS (SELECT NULL
568: FROM MTL_ITEM_REVISIONS_TL T
569: WHERE T.INVENTORY_ITEM_ID = X_item_id
570: AND T.ORGANIZATION_ID = X_org_id
571: AND T.REVISION_ID = l_revision_id
572: AND T.LANGUAGE = L.LANGUAGE_CODE);