APPS.ICX_POR_EXT_ITEM dependencies on ICX_CAT_CATEGORIES_TL

Line 45: category_key icx_cat_categories_tl.key%TYPE,

41: inventory_organization_id NUMBER,
42: item_source_type icx_cat_items_tlp.item_source_type%TYPE,
43: item_search_type icx_cat_items_tlp.search_type%TYPE,
44: mtl_category_id NUMBER,
45: category_key icx_cat_categories_tl.key%TYPE,
46: description icx_cat_items_tlp.description%TYPE,
47: picture icx_cat_items_tlp.picture%TYPE,
48: picture_url icx_cat_items_tlp.picture_url%TYPE,
49: price_type icx_cat_item_prices.price_type%TYPE,

Line 88: primary_category_name icx_cat_categories_tl.category_name%TYPE,

84: buyer_id NUMBER,
85: global_agreement_flag VARCHAR2(1),
86: status NUMBER,
87: primary_category_id NUMBER,
88: primary_category_name icx_cat_categories_tl.category_name%TYPE,
89: template_category_id NUMBER,
90: price_rt_item_id NUMBER,
91: price_internal_item_id NUMBER,
92: price_supplier_id NUMBER,

Line 2835: FROM icx_cat_categories_tl c

2831: FORALL i IN 1..xRtItemIds.COUNT
2832: DELETE FROM icx_cat_category_items ci
2833: WHERE rt_item_id = xRtItemIds(i)
2834: AND EXISTS (SELECT 'template header'
2835: FROM icx_cat_categories_tl c
2836: WHERE c.rt_category_id = ci.rt_category_id
2837: AND c.type = ICX_POR_EXT_CLASS.TEMPLATE_HEADER_TYPE);
2838:
2839: xErrLoc := 560;

Line 3716: xString := xString || 'icx_cat_categories_tl ctl ';

3712: ELSE
3713: xString := xString ||
3714: 'FROM mtl_system_items_tl m, ';
3715: END IF;
3716: xString := xString || 'icx_cat_categories_tl ctl ';
3717: --Bug#3004696: language=source_lan is necessary so that
3718: -- only translated items are extracted. pseudo translated items
3719: -- are not extracted. e.g. Item created in english, but rows get added to
3720: -- other installed langs. extract the item only in english

Line 3879: xString := xString || 'icx_cat_categories_tl ctl, ';

3875: xString := xString ||
3876: 'FROM mtl_system_items_tl m, ' ;
3877: END IF;
3878:
3879: xString := xString || 'icx_cat_categories_tl ctl, ';
3880: --Bug#3004696: language=source_lan is necessary so that
3881: -- only translated items are extracted. pseudo translated items
3882: -- are not extracted. e.g. Item created in english, but rows get added to
3883: -- other installed langs. extract the item only in english

Line 6349: 'icx_cat_categories_tl ic1, ' ||

6345: END IF;
6346:
6347: xErrLoc := 300;
6348: xFromStr :=
6349: 'icx_cat_categories_tl ic1, ' ||
6350: 'icx_por_category_data_sources ds1, ';
6351: IF pType = 'TEMPLATE' THEN
6352: xFromStr := xFromStr ||
6353: 'icx_cat_categories_tl ic2, '||

Line 6353: 'icx_cat_categories_tl ic2, '||

6349: 'icx_cat_categories_tl ic1, ' ||
6350: 'icx_por_category_data_sources ds1, ';
6351: IF pType = 'TEMPLATE' THEN
6352: xFromStr := xFromStr ||
6353: 'icx_cat_categories_tl ic2, '||
6354: 'icx_por_category_data_sources ds2, ';
6355: END IF;
6356: xFromStr := xFromStr ||
6357: 'icx_cat_item_prices p, '||

Line 6358: 'icx_cat_categories_tl ic3, '||

6354: 'icx_por_category_data_sources ds2, ';
6355: END IF;
6356: xFromStr := xFromStr ||
6357: 'icx_cat_item_prices p, '||
6358: 'icx_cat_categories_tl ic3, '||
6359: 'icx_por_category_data_sources ds3, '||
6360: 'icx_cat_items_b i ';
6361:
6362: xErrLoc := 400;

Line 7398: 'icx_cat_categories_tl ic '||

7394: 'p.inventory_item_id, '||
7395: 'p.org_id, '||
7396: 'p.local_rt_item_id '||
7397: 'FROM icx_cat_item_prices p, '||
7398: 'icx_cat_categories_tl ic '||
7399: 'WHERE p.price_type IN (''TEMPLATE'', ''INTERNAL_TEMPLATE'', ' ||
7400: ' ''BLANKET'', ''QUOTATION'', ''GLOBAL_AGREEMENT'', ''ASL'', ' ||
7401: ' ''PURCHASING_ITEM'', ''INTERNAL_ITEM'') ' ||
7402: 'AND ICX_POR_EXT_DIAG.getPriceStatus(p.price_type, p.rowid, '''||