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.ICX_POR_EXT_ITEM dependencies on ICX_CAT_EXTRACT_GT

Line 1549: ' icx_cat_extract_gt i ' ||

1545: 'FROM po_reqexpress_lines_all t, ' ;
1546: END IF;
1547: xString := xString ||
1548: ' icx_cat_item_prices p, ' ||
1549: ' icx_cat_extract_gt i ' ||
1550: 'WHERE NVL(t.org_id, -2) = p.org_id ' ||
1551: ' AND t.express_name = p.template_id ' ||
1552: ' AND t.sequence_num = p.template_line_id ' ||
1553: ' AND i.type = ''ACTIVE_FLAG'' ' ||

Line 1569: ' icx_cat_extract_gt i ' ||

1565: 'FROM po_lines_all t, ' ;
1566: END IF;
1567: xString := xString ||
1568: ' icx_cat_item_prices p, ' ||
1569: ' icx_cat_extract_gt i ' ||
1570: 'WHERE NVL(t.org_id, -2) = p.org_id ' ||
1571: ' AND t.po_line_id = p.contract_line_id ' ||
1572: ' AND i.type = ''ACTIVE_FLAG'' ' ||
1573: ' AND p.active_flag = ''Y'' ' ||

Line 1593: ' icx_cat_extract_gt i ' ||

1589: END IF;
1590: xString := xString ||
1591: ' fnd_languages lang, ' ||
1592: ' icx_cat_item_prices p, ' ||
1593: ' icx_cat_extract_gt i ' ||
1594: 'WHERE NVL(fsp.org_id, -2) = p.org_id ' ||
1595: ' AND t.asl_id = p.asl_id ' ||
1596: ' AND t.owning_organization_id = fsp.inventory_organization_id ' ||
1597: ' AND t.item_id = mitl.inventory_item_id ' ||

Line 1620: ' icx_cat_extract_gt i ' ||

1616: END IF;
1617: xString := xString ||
1618: ' fnd_languages lang, ' ||
1619: ' icx_cat_item_prices p, ' ||
1620: ' icx_cat_extract_gt i ' ||
1621: 'WHERE NVL(fsp.org_id, -2) = p.org_id ' ||
1622: ' AND t.inventory_item_id = p.inventory_item_id ' ||
1623: ' AND t.organization_id = fsp.inventory_organization_id ' ||
1624: ' AND t.language = lang.language_code ' ||

Line 2584: INSERT INTO icx_cat_extract_gt

2580: xErrLoc := 398;
2581: -- Need to reset active_flag for all local rt_item_ids
2582: -- NOTE: we use local_rt_item_id to store local rt_item_id
2583: FORALL i IN 1..xRtItemIds.COUNT
2584: INSERT INTO icx_cat_extract_gt
2585: (rt_item_id, type)
2586: VALUES (xRtItemIds(i), 'ACTIVE_FLAG');
2587: clearTables(xActionMode);
2588:

Line 2723: INSERT INTO icx_cat_extract_gt

2719: snapShot(i, xActionMode));
2720: END LOOP;
2721: END IF;
2722: FORALL i IN 1..gCIRtItemIds.COUNT
2723: INSERT INTO icx_cat_extract_gt
2724: (rt_item_id, type)
2725: VALUES (gCIRtItemIds(i), 'CLEANUP_ITEM');
2726: clearTables(xActionMode);
2727:

Line 2753: INSERT INTO icx_cat_extract_gt

2749: snapShot(i, xActionMode));
2750: END LOOP;
2751: END IF;
2752: FORALL i IN 1..gTARtItemIds.COUNT
2753: INSERT INTO icx_cat_extract_gt
2754: (rt_item_id, type)
2755: VALUES (gTARtItemIds(i), 'ACTIVE_FLAG');
2756: clearTables(xActionMode);
2757:

Line 2768: INSERT INTO icx_cat_extract_gt

2764: snapShot(i, xActionMode));
2765: END LOOP;
2766: END IF;
2767: FORALL i IN 1..gTAInvItemIds.COUNT
2768: INSERT INTO icx_cat_extract_gt
2769: (rt_item_id, type)
2770: SELECT rt_item_id, 'ACTIVE_FLAG'
2771: FROM icx_cat_items_b
2772: WHERE internal_item_id = gTAInvItemIds(i)

Line 2818: INSERT INTO icx_cat_extract_gt

2814:
2815: xErrLoc := 545;
2816: -- Insert temporary table to cleanup items
2817: FORALL i IN 1..xRtItemIds.COUNT
2818: INSERT INTO icx_cat_extract_gt
2819: (rt_item_id, type)
2820: VALUES (xRtItemIds(i), 'CLEANUP_ITEM');
2821:
2822: xErrLoc := 550;

Line 2874: INSERT INTO icx_cat_extract_gt

2870:
2871: xErrLoc := 590;
2872: -- Insert temporary table to cleanup items
2873: FORALL i IN 1..xRtItemIds.COUNT
2874: INSERT INTO icx_cat_extract_gt
2875: (rt_item_id, type)
2876: VALUES (xRtItemIds(i), 'CLEANUP_ITEM');
2877:
2878: IF (SQL%ROWCOUNT < ICX_POR_EXT_UTL.gCommitSize) THEN

Line 2917: INSERT INTO icx_cat_extract_gt

2913:
2914: xErrLoc := 630;
2915: -- Insert temporary table to cleanup items
2916: FORALL i IN 1..xRtItemIds.COUNT
2917: INSERT INTO icx_cat_extract_gt
2918: (rt_item_id, type)
2919: VALUES (xRtItemIds(i), 'CLEANUP_ITEM');
2920:
2921: IF (SQL%ROWCOUNT < ICX_POR_EXT_UTL.gCommitSize) THEN

Line 7068: 'TRUNCATE TABLE '||xIcxSchema||'.icx_cat_extract_gt';

7064: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.INFO_LEVEL,
7065: 'Truncate global temporary table');
7066: xErrLoc := 160;
7067: EXECUTE IMMEDIATE
7068: 'TRUNCATE TABLE '||xIcxSchema||'.icx_cat_extract_gt';
7069: xErrLoc := 200;
7070: IF pType = 'ALL' THEN
7071: EXECUTE IMMEDIATE
7072: 'TRUNCATE TABLE '||xIcxSchema||'.icx_cat_extract_ga_gt';

Line 7091: FROM icx_cat_extract_gt i

7087: xRowCount PLS_INTEGER := 0;
7088:
7089: CURSOR cItemNoPrices IS
7090: SELECT i.rt_item_id
7091: FROM icx_cat_extract_gt i
7092: WHERE i.type = 'CLEANUP_ITEM'
7093: AND NOT EXISTS (SELECT 'price rows'
7094: FROM icx_cat_item_prices p
7095: WHERE p.rt_item_id = i.rt_item_id);

Line 7189: icx_cat_extract_gt i

7185: p.rt_item_id,
7186: p.rowid price_rowid,
7187: ICX_POR_EXT_ITEM.getActiveFlag(p.price_type, p.rowid) active_flag
7188: FROM icx_cat_item_prices p,
7189: icx_cat_extract_gt i
7190: WHERE i.type = 'ACTIVE_FLAG'
7191: AND p.rt_item_id = i.rt_item_id
7192: AND p.price_type <> 'GLOBAL_AGREEMENT'
7193: AND nvl(p.request_id, ICX_POR_EXT_ITEM.AF_NEW_PRICE_TEMP_REQUEST_ID) <>

Line 7469: INSERT INTO icx_cat_extract_gt

7465:
7466: xErrLoc := 280;
7467: -- Insert temporary table to cleanup items
7468: FORALL i IN 1..gDPRtItemIds.COUNT
7469: INSERT INTO icx_cat_extract_gt
7470: (rt_item_id, type)
7471: VALUES (gDPRtItemIds(i), 'CLEANUP_ITEM');
7472:
7473: -- Insert temporary table to set active flags

Line 7475: INSERT INTO icx_cat_extract_gt

7471: VALUES (gDPRtItemIds(i), 'CLEANUP_ITEM');
7472:
7473: -- Insert temporary table to set active flags
7474: FORALL i IN 1..gDPRtItemIds.COUNT
7475: INSERT INTO icx_cat_extract_gt
7476: (rt_item_id, type)
7477: VALUES (gDPRtItemIds(i), 'ACTIVE_FLAG');
7478:
7479: FORALL i IN 1..gDPInventoryItemIds.COUNT

Line 7480: INSERT INTO icx_cat_extract_gt

7476: (rt_item_id, type)
7477: VALUES (gDPRtItemIds(i), 'ACTIVE_FLAG');
7478:
7479: FORALL i IN 1..gDPInventoryItemIds.COUNT
7480: INSERT INTO icx_cat_extract_gt
7481: (rt_item_id, type)
7482: SELECT rt_item_id, 'ACTIVE_FLAG'
7483: FROM icx_cat_items_b
7484: WHERE internal_item_id = gDPInventoryItemIds(i)

Line 7491: INSERT INTO icx_cat_extract_gt

7487:
7488: -- Ignore null local rt_item_id values
7489: -- Local rt_item_id not-null only for local org assignments of a global org
7490: FORALL i IN 1..gDPLocalRtItemIds.COUNT
7491: INSERT INTO icx_cat_extract_gt
7492: (rt_item_id, type)
7493: SELECT gDPLocalRtItemIds(i), 'ACTIVE_FLAG'
7494: FROM dual
7495: WHERE gDPLocalRtItemIds(i) IS NOT NULL;