APPS.ICX_POR_EXT_ITEM dependencies on ICX_CAT_EXTRACT_GA_GT

Line 2738: INSERT INTO icx_cat_extract_ga_gt

2734: snapShot(i, xActionMode));
2735: END LOOP;
2736: END IF;
2737: FORALL i IN 1..gUGAContractIds.COUNT
2738: INSERT INTO icx_cat_extract_ga_gt
2739: (contract_id, contract_line_id)
2740: VALUES (gUGAContractIds(i), gUGAContractLineIds(i));
2741: clearTables(xActionMode);
2742:

Line 6709: 'icx_cat_extract_ga_gt g, '||

6705: 'TO_CHAR(NULL) match_template_flag, '||
6706: 'TO_CHAR(NULL) active_flag, '||
6707: 'ROWIDTOCHAR(p.rowid) price_rowid '||
6708: 'FROM icx_cat_item_prices p, '||
6709: 'icx_cat_extract_ga_gt g, '||
6710: 'icx_cat_items_b i '||
6711: 'WHERE p.contract_id = g.contract_id '||
6712: 'AND p.contract_line_id = g.contract_line_id '||
6713: 'AND p.price_type = ''GLOBAL_AGREEMENT'' '||

Line 7072: 'TRUNCATE TABLE '||xIcxSchema||'.icx_cat_extract_ga_gt';

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';
7073: END IF;
7074: xErrLoc := 300;
7075: EXCEPTION
7076: when others then