eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_ITEM_PVT dependencies on EGO_ITEM_TEXT_TL

Line 6291: This Trigger causes a insert into EGO_ITEM_TEXT_TL for each row inserted into

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
6295: and ask customer to launch the concurrent request to build the intermedia index

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 6299: /* Drop index EGO_ITEM_TEXT_TL_CTX1. For that, we need to get the EGO schema name first. */

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:
6299: /* Drop index EGO_ITEM_TEXT_TL_CTX1. For that, we need to get the EGO schema name first. */
6300: l_installed := FND_INSTALLATION.Get_App_Info ('EGO', l_inst_status, l_industry, l_Prod_Schema);
6301:
6302: /* Check if index exists before dropping it*/
6303: BEGIN

Line 6306: WHERE table_name = 'EGO_ITEM_TEXT_TL'

6302: /* Check if index exists before dropping it*/
6303: BEGIN
6304: SELECT index_name into l_index_name
6305: FROM all_indexes
6306: WHERE table_name = 'EGO_ITEM_TEXT_TL'
6307: AND index_name = 'EGO_ITEM_TEXT_TL_CTX1'
6308: AND owner = l_prod_schema;
6309: EXCEPTION
6310: WHEN NO_DATA_FOUND THEN

Line 6307: AND index_name = 'EGO_ITEM_TEXT_TL_CTX1'

6303: BEGIN
6304: SELECT index_name into l_index_name
6305: FROM all_indexes
6306: WHERE table_name = 'EGO_ITEM_TEXT_TL'
6307: AND index_name = 'EGO_ITEM_TEXT_TL_CTX1'
6308: AND owner = l_prod_schema;
6309: EXCEPTION
6310: WHEN NO_DATA_FOUND THEN
6311: l_index_name := NULL;

Line 6314: IF(l_index_name = 'EGO_ITEM_TEXT_TL_CTX1') THEN

6310: WHEN NO_DATA_FOUND THEN
6311: l_index_name := NULL;
6312: END;
6313:
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 */

Line 6315: EXECUTE IMMEDIATE 'DROP INDEX ' || l_Prod_Schema || '.EGO_ITEM_TEXT_TL_CTX1 FORCE;';

6311: l_index_name := NULL;
6312: END;
6313:
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

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 6373: /* Next insert missing language records into EGO_ITEM_TEXT_TL

6369: AND T.ORGANIZATION_ID = B.ORGANIZATION_ID
6370: AND T.LANGUAGE = L.LANGUAGE_CODE);
6371:
6372:
6373: /* Next insert missing language records into EGO_ITEM_TEXT_TL
6374: Fix for bug 12922572 : FP of Bug 5701472
6375: Query suggested by performance team to use PARALLEL dml
6376: */
6377:

Line 6380: INTO EGO_ITEM_TEXT_TL TL

6376: */
6377:
6378: INSERT
6379: /*+ APPEND PARALLEL (TL) */
6380: INTO EGO_ITEM_TEXT_TL TL
6381: (
6382: ID_TYPE ,
6383: ITEM_ID ,
6384: ITEM_CODE ,

Line 6426: FROM EGO_ITEM_TEXT_TL EITL1

6422: (SELECT
6423: /*+ UNNEST FULL (EITL1) PARALLEL (EITL1) */
6424: EITL1.ITEM_ID,
6425: EITL1.ORG_ID
6426: FROM EGO_ITEM_TEXT_TL EITL1
6427: WHERE EITL1.ID_TYPE = '$$INTERNAL$$'
6428: AND EITL1.LANGUAGE = L.LANGUAGE_CODE
6429: );
6430:

Line 6432: EGO_ITEM_TEXT_TL table in sync during normal apps operations.

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
6436: 'ALTER TRIGGER EGO_MTL_SYSTEM_ITEMS_TL_TR1 ENABLE';