DBA Data[Home] [Help]

APPS.INV_ITEM_PVT dependencies on MTL_SYSTEM_ITEMS_TL

Line 710: FROM mtl_system_items_tl

706: l_update_child_rec := FALSE; --Bug: 5220205
707: -- Bug 4388141. Populate long description in l_item_rec.long_description
708: SELECT description , long_description
709: INTO l_item_rec.description , l_item_rec.long_description
710: FROM mtl_system_items_tl
711: WHERE inventory_item_id = l_item_rec.inventory_item_id
712: AND organization_id = l_item_rec.organization_id
713: AND language = userenv('LANG');
714: --bug 9944329, check if status has been changed in master org

Line 4249: INSERT INTO MTL_SYSTEM_ITEMS_TL(

4245: IF (P_Item_Rec.organization_id = Get_Master_Org_ID (P_Item_Rec.organization_id) ) THEN
4246: -- If the Org is master, insert the source language translated columns
4247: -- for child organizations.
4248:
4249: INSERT INTO MTL_SYSTEM_ITEMS_TL(
4250: INVENTORY_ITEM_ID,
4251: ORGANIZATION_ID,
4252: LANGUAGE,
4253: SOURCE_LANG,

Line 4277: FROM MTL_SYSTEM_ITEMS_TL T

4273: FROM FND_LANGUAGES L
4274: WHERE L.INSTALLED_FLAG in ('I', 'B')
4275: AND NOT EXISTS
4276: ( SELECT NULL
4277: FROM MTL_SYSTEM_ITEMS_TL T
4278: WHERE T.INVENTORY_ITEM_ID = P_Item_Rec.INVENTORY_ITEM_ID
4279: AND T.ORGANIZATION_ID = P_Item_Rec.ORGANIZATION_ID
4280: AND T.LANGUAGE = L.LANGUAGE_CODE);
4281: ELSE

Line 4284: INSERT INTO MTL_SYSTEM_ITEMS_TL (

4280: AND T.LANGUAGE = L.LANGUAGE_CODE);
4281: ELSE
4282: -- If the Org is not master, then while creating new child items,
4283: -- copy translated columns from the master item record.
4284: INSERT INTO MTL_SYSTEM_ITEMS_TL (
4285: INVENTORY_ITEM_ID,
4286: ORGANIZATION_ID,
4287: LANGUAGE,
4288: SOURCE_LANG,

Line 4309: MTL_SYSTEM_ITEMS_TL MSI,

4305: P_Item_Rec.CREATION_DATE,
4306: P_Item_Rec.CREATED_BY,
4307: P_Item_Rec.LAST_UPDATE_LOGIN
4308: FROM
4309: MTL_SYSTEM_ITEMS_TL MSI,
4310: MTL_PARAMETERS MP
4311: WHERE
4312: MSI.INVENTORY_ITEM_ID = P_Item_Rec.INVENTORY_ITEM_ID
4313: AND MSI.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID

Line 5512: FROM MTL_SYSTEM_ITEMS_TL

5508: SELECT
5509: DESCRIPTION,
5510: LONG_DESCRIPTION,
5511: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
5512: FROM MTL_SYSTEM_ITEMS_TL
5513: WHERE INVENTORY_ITEM_ID = P_Item_Rec.inventory_item_id
5514: AND ORGANIZATION_ID = P_Item_rec.organization_id
5515: for update of INVENTORY_ITEM_ID nowait;
5516:

Line 6256: /* DELETE FROM MTL_SYSTEM_ITEMS_TL T

6252: l_installed BOOLEAN;
6253: l_index_name VARCHAR2(30);
6254: BEGIN
6255:
6256: /* DELETE FROM MTL_SYSTEM_ITEMS_TL T
6257: WHERE NOT EXISTS ( SELECT NULL
6258: FROM MTL_SYSTEM_ITEMS_B B
6259: WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
6260: AND B.ORGANIZATION_ID = T.ORGANIZATION_ID);

Line 6262: UPDATE MTL_SYSTEM_ITEMS_TL T

6258: FROM MTL_SYSTEM_ITEMS_B B
6259: WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
6260: AND B.ORGANIZATION_ID = T.ORGANIZATION_ID);
6261:
6262: UPDATE MTL_SYSTEM_ITEMS_TL T
6263: SET( DESCRIPTION
6264: , LONG_DESCRIPTION) = (SELECT ltrim(rtrim(B.DESCRIPTION))
6265: , ltrim(rtrim(B.LONG_DESCRIPTION))
6266: FROM MTL_SYSTEM_ITEMS_TL B

Line 6266: FROM MTL_SYSTEM_ITEMS_TL B

6262: UPDATE MTL_SYSTEM_ITEMS_TL T
6263: SET( DESCRIPTION
6264: , LONG_DESCRIPTION) = (SELECT ltrim(rtrim(B.DESCRIPTION))
6265: , ltrim(rtrim(B.LONG_DESCRIPTION))
6266: FROM MTL_SYSTEM_ITEMS_TL B
6267: WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
6268: AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
6269: AND B.LANGUAGE = T.SOURCE_LANG)
6270: WHERE(T.INVENTORY_ITEM_ID

Line 6275: FROM MTL_SYSTEM_ITEMS_TL SUBB,

6271: , T.ORGANIZATION_ID
6272: , T.LANGUAGE) IN (SELECT SUBT.INVENTORY_ITEM_ID,
6273: SUBT.ORGANIZATION_ID,
6274: SUBT.LANGUAGE
6275: FROM MTL_SYSTEM_ITEMS_TL SUBB,
6276: MTL_SYSTEM_ITEMS_TL SUBT
6277: WHERE SUBB.INVENTORY_ITEM_ID = SUBT.INVENTORY_ITEM_ID
6278: AND SUBB.ORGANIZATION_ID = SUBT.ORGANIZATION_ID
6279: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 6276: MTL_SYSTEM_ITEMS_TL SUBT

6272: , T.LANGUAGE) IN (SELECT SUBT.INVENTORY_ITEM_ID,
6273: SUBT.ORGANIZATION_ID,
6274: SUBT.LANGUAGE
6275: FROM MTL_SYSTEM_ITEMS_TL SUBB,
6276: MTL_SYSTEM_ITEMS_TL SUBT
6277: WHERE SUBB.INVENTORY_ITEM_ID = SUBT.INVENTORY_ITEM_ID
6278: AND SUBB.ORGANIZATION_ID = SUBT.ORGANIZATION_ID
6279: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
6280: AND (( SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 6290: MTL_SYSTEM_ITEMS_TL has a row level trigger: EGO_MTL_SYSTEM_ITEMS_TL_TR1

6286:
6287: */
6288:
6289: /* Fix for bug 12922572 : FP of Bug 5701472-
6290: MTL_SYSTEM_ITEMS_TL has a row level trigger: EGO_MTL_SYSTEM_ITEMS_TL_TR1
6291: This Trigger causes a insert into EGO_ITEM_TEXT_TL for each row inserted into
6292: MTL_SYSTEM_ITEMS_TL, which causes performance issues. As part of bug 5701472,
6293: we will drop the intermedia index, disable trigger EGO_MTL_SYSTEM_ITEMS_TL_TR1
6294: batch insert into MTL_SYSTEM_ITEMS_TL and EGO_ITEM_TEXT_TL, enable the trigger

Line 6292: MTL_SYSTEM_ITEMS_TL, which causes performance issues. As part of bug 5701472,

6288:
6289: /* Fix for bug 12922572 : FP of Bug 5701472-
6290: MTL_SYSTEM_ITEMS_TL has a row level trigger: EGO_MTL_SYSTEM_ITEMS_TL_TR1
6291: This Trigger causes a insert into EGO_ITEM_TEXT_TL for each row inserted into
6292: MTL_SYSTEM_ITEMS_TL, which causes performance issues. As part of bug 5701472,
6293: we will drop the intermedia index, disable trigger EGO_MTL_SYSTEM_ITEMS_TL_TR1
6294: batch insert into MTL_SYSTEM_ITEMS_TL and EGO_ITEM_TEXT_TL, enable the trigger
6295: and ask customer to launch the concurrent request to build the intermedia index
6296: (Item Catalog Text Index Build with CREATE option).*/

Line 6293: we will drop the intermedia index, disable trigger EGO_MTL_SYSTEM_ITEMS_TL_TR1

6289: /* Fix for bug 12922572 : FP of Bug 5701472-
6290: MTL_SYSTEM_ITEMS_TL has a row level trigger: EGO_MTL_SYSTEM_ITEMS_TL_TR1
6291: This Trigger causes a insert into EGO_ITEM_TEXT_TL for each row inserted into
6292: MTL_SYSTEM_ITEMS_TL, which causes performance issues. As part of bug 5701472,
6293: we will drop the intermedia index, disable trigger EGO_MTL_SYSTEM_ITEMS_TL_TR1
6294: batch insert into MTL_SYSTEM_ITEMS_TL and EGO_ITEM_TEXT_TL, enable the trigger
6295: and ask customer to launch the concurrent request to build the intermedia index
6296: (Item Catalog Text Index Build with CREATE option).*/
6297:

Line 6294: batch insert into MTL_SYSTEM_ITEMS_TL and EGO_ITEM_TEXT_TL, enable the trigger

6290: MTL_SYSTEM_ITEMS_TL has a row level trigger: EGO_MTL_SYSTEM_ITEMS_TL_TR1
6291: This Trigger causes a insert into EGO_ITEM_TEXT_TL for each row inserted into
6292: MTL_SYSTEM_ITEMS_TL, which causes performance issues. As part of bug 5701472,
6293: we will drop the intermedia index, disable trigger EGO_MTL_SYSTEM_ITEMS_TL_TR1
6294: batch insert into MTL_SYSTEM_ITEMS_TL and EGO_ITEM_TEXT_TL, enable the trigger
6295: and ask customer to launch the concurrent request to build the intermedia index
6296: (Item Catalog Text Index Build with CREATE option).*/
6297:
6298:

Line 6318: /*Disable Trigger EGO_MTL_SYSTEM_ITEMS_TL_TR1, and we will bulk insert into EGO_ITEM_TEXT_TL */

6314: IF(l_index_name = 'EGO_ITEM_TEXT_TL_CTX1') THEN
6315: EXECUTE IMMEDIATE 'DROP INDEX ' || l_Prod_Schema || '.EGO_ITEM_TEXT_TL_CTX1 FORCE;';
6316: END IF;
6317:
6318: /*Disable Trigger EGO_MTL_SYSTEM_ITEMS_TL_TR1, and we will bulk insert into EGO_ITEM_TEXT_TL */
6319: EXECUTE IMMEDIATE
6320: 'ALTER TRIGGER EGO_MTL_SYSTEM_ITEMS_TL_TR1 DISABLE';
6321:
6322: /*

Line 6320: 'ALTER TRIGGER EGO_MTL_SYSTEM_ITEMS_TL_TR1 DISABLE';

6316: END IF;
6317:
6318: /*Disable Trigger EGO_MTL_SYSTEM_ITEMS_TL_TR1, and we will bulk insert into EGO_ITEM_TEXT_TL */
6319: EXECUTE IMMEDIATE
6320: 'ALTER TRIGGER EGO_MTL_SYSTEM_ITEMS_TL_TR1 DISABLE';
6321:
6322: /*
6323: Fix for bug 12922572 : FP of Bug 5701472-
6324: Disable the trigger MTL_SYSTEM_ITEMS_TL_TA_IBE based on the suggestions from IBE team

Line 6324: Disable the trigger MTL_SYSTEM_ITEMS_TL_TA_IBE based on the suggestions from IBE team

6320: 'ALTER TRIGGER EGO_MTL_SYSTEM_ITEMS_TL_TR1 DISABLE';
6321:
6322: /*
6323: Fix for bug 12922572 : FP of Bug 5701472-
6324: Disable the trigger MTL_SYSTEM_ITEMS_TL_TA_IBE based on the suggestions from IBE team
6325: in bug 5725517. Users need to run iStore Search concurrent programs for inserting
6326: into IBE_CT_IMEDIA_SEARCH
6327: */
6328: EXECUTE IMMEDIATE

Line 6329: 'ALTER TRIGGER MTL_SYSTEM_ITEMS_TL_TA_IBE DISABLE';

6325: in bug 5725517. Users need to run iStore Search concurrent programs for inserting
6326: into IBE_CT_IMEDIA_SEARCH
6327: */
6328: EXECUTE IMMEDIATE
6329: 'ALTER TRIGGER MTL_SYSTEM_ITEMS_TL_TA_IBE DISABLE';
6330:
6331: /*First insert missing language records into MTL_SYSTEM_ITEMS_TL*/
6332:
6333: INSERT

Line 6331: /*First insert missing language records into MTL_SYSTEM_ITEMS_TL*/

6327: */
6328: EXECUTE IMMEDIATE
6329: 'ALTER TRIGGER MTL_SYSTEM_ITEMS_TL_TA_IBE DISABLE';
6330:
6331: /*First insert missing language records into MTL_SYSTEM_ITEMS_TL*/
6332:
6333: INSERT
6334: /*+ APPEND PARALLEL(tt) */
6335: INTO MTL_SYSTEM_ITEMS_TL tt

Line 6335: INTO MTL_SYSTEM_ITEMS_TL tt

6331: /*First insert missing language records into MTL_SYSTEM_ITEMS_TL*/
6332:
6333: INSERT
6334: /*+ APPEND PARALLEL(tt) */
6335: INTO MTL_SYSTEM_ITEMS_TL tt
6336: (
6337: INVENTORY_ITEM_ID
6338: ,ORGANIZATION_ID
6339: ,DESCRIPTION

Line 6362: FROM MTL_SYSTEM_ITEMS_TL B ,

6358: ,B.CREATED_BY
6359: ,B.LAST_UPDATE_LOGIN
6360: ,L.LANGUAGE_CODE
6361: ,B.SOURCE_LANG
6362: FROM MTL_SYSTEM_ITEMS_TL B ,
6363: FND_LANGUAGES L
6364: WHERE L.INSTALLED_FLAG IN ( 'I','B' )
6365: AND B.LANGUAGE = USERENV ( 'LANG' )
6366: AND NOT EXISTS( SELECT /*+ parallel(t) */ NULL

Line 6367: FROM MTL_SYSTEM_ITEMS_TL T

6363: FND_LANGUAGES L
6364: WHERE L.INSTALLED_FLAG IN ( 'I','B' )
6365: AND B.LANGUAGE = USERENV ( 'LANG' )
6366: AND NOT EXISTS( SELECT /*+ parallel(t) */ NULL
6367: FROM MTL_SYSTEM_ITEMS_TL T
6368: WHERE T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
6369: AND T.ORGANIZATION_ID = B.ORGANIZATION_ID
6370: AND T.LANGUAGE = L.LANGUAGE_CODE);
6371:

Line 6431: /* Enable Trigger EGO_MTL_SYSTEM_ITEMS_TL_TR1. This will be required to keep

6427: WHERE EITL1.ID_TYPE = '$$INTERNAL$$'
6428: AND EITL1.LANGUAGE = L.LANGUAGE_CODE
6429: );
6430:
6431: /* Enable Trigger EGO_MTL_SYSTEM_ITEMS_TL_TR1. This will be required to keep
6432: EGO_ITEM_TEXT_TL table in sync during normal apps operations.
6433: */
6434:
6435: EXECUTE IMMEDIATE

Line 6436: 'ALTER TRIGGER EGO_MTL_SYSTEM_ITEMS_TL_TR1 ENABLE';

6432: EGO_ITEM_TEXT_TL table in sync during normal apps operations.
6433: */
6434:
6435: EXECUTE IMMEDIATE
6436: 'ALTER TRIGGER EGO_MTL_SYSTEM_ITEMS_TL_TR1 ENABLE';
6437:
6438: /* Enable the trigger MTL_SYSTEM_ITEMS_TL_TA_IBE. This will be required to keep
6439: IBE_CT_IMEDIA_SEARCH in sync during normal apps operations.
6440: */

Line 6438: /* Enable the trigger MTL_SYSTEM_ITEMS_TL_TA_IBE. This will be required to keep

6434:
6435: EXECUTE IMMEDIATE
6436: 'ALTER TRIGGER EGO_MTL_SYSTEM_ITEMS_TL_TR1 ENABLE';
6437:
6438: /* Enable the trigger MTL_SYSTEM_ITEMS_TL_TA_IBE. This will be required to keep
6439: IBE_CT_IMEDIA_SEARCH in sync during normal apps operations.
6440: */
6441: EXECUTE IMMEDIATE
6442: 'ALTER TRIGGER MTL_SYSTEM_ITEMS_TL_TA_IBE ENABLE';

Line 6442: 'ALTER TRIGGER MTL_SYSTEM_ITEMS_TL_TA_IBE ENABLE';

6438: /* Enable the trigger MTL_SYSTEM_ITEMS_TL_TA_IBE. This will be required to keep
6439: IBE_CT_IMEDIA_SEARCH in sync during normal apps operations.
6440: */
6441: EXECUTE IMMEDIATE
6442: 'ALTER TRIGGER MTL_SYSTEM_ITEMS_TL_TA_IBE ENABLE';
6443:
6444: /*Commit and call sync index so that iM index is in sync.*/
6445: COMMIT;
6446:

Line 6471: FROM MTL_SYSTEM_ITEMS_TL

6467: ,LANGUAGE
6468: ,SOURCE_LANG
6469: ,DESCRIPTION
6470: ,LONG_DESCRIPTION
6471: FROM MTL_SYSTEM_ITEMS_TL
6472: WHERE INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID
6473: AND ORGANIZATION_ID IN ( SELECT ORGANIZATION_ID
6474: FROM MTL_PARAMETERS
6475: WHERE MASTER_ORGANIZATION_ID = X_ORGANIZATION_ID

Line 6530: update mtl_system_items_tl

6526: end if;
6527: --- bug 8717482 vggarg end changes
6528:
6529: /*
6530: update mtl_system_items_tl
6531: set description = ltrim(rtrim(x_description)),
6532: long_description = ltrim(rtrim(x_long_description)),
6533: source_lang = x_language,
6534: last_updated_by = fnd_profile.value('USER_ID'),

Line 6543: update mtl_system_items_tl

6539: */
6540: for c1 in Item_csr
6541: loop
6542: if (l_desc_control = 1) and c1.description <> ltrim(rtrim(x_description)) then -- bug 14599786 for second issue
6543: update mtl_system_items_tl
6544: set description = ltrim(rtrim(x_description)),
6545: source_lang = x_language,
6546: last_update_date = sysdate,
6547: last_updated_by = fnd_profile.value('USER_ID'),

Line 6554: update mtl_system_items_tl

6550:
6551: end if;
6552:
6553: if (l_longdesc_control = 1) and c1.long_description <> ltrim(rtrim(x_long_description)) then -- bug 14599786 for second issue
6554: update mtl_system_items_tl
6555: set long_description = ltrim(rtrim(x_long_description)),
6556: source_lang = x_language,
6557: last_update_date = sysdate,
6558: last_updated_by = fnd_profile.value('USER_ID'),