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_CAT_R12_UPGRADE_PVT dependencies on ICX_CAT_ITEM_PRICES

Line 63: req_template_name icx_cat_item_prices.template_id%TYPE,

59: vendor_product_num po_lines_interface.vendor_product_num%TYPE,
60: supplier_part_auxid po_lines_interface.supplier_part_auxid%TYPE,
61: item_description po_lines_interface.item_description%TYPE,
62: catalog_name po_lines_interface.catalog_name%TYPE,
63: req_template_name icx_cat_item_prices.template_id%TYPE,
64: req_template_line_num NUMBER,
65: inventory_item_id NUMBER,
66: org_id NUMBER,
67: rt_item_id NUMBER,

Line 2063: FROM icx_cat_item_prices p

2059: --populate the attribute and attribute values tlp
2060: IF (g_extract_last_run_date IS NULL) THEN
2061: OPEN p_blanketAndQuoteHdrs_csr FOR
2062: SELECT distinct p.contract_id po_header_id, p.price_type, p.org_id
2063: FROM icx_cat_item_prices p
2064: WHERE p.price_type IN ('BLANKET', 'QUOTATION')
2065: AND p.contract_id >= p_start_po_header_id
2066: ORDER BY p.contract_id;
2067: ELSE

Line 2071: FROM icx_cat_item_prices p, icx_cat_items_tlp itemtlp,

2067: ELSE
2068: l_err_loc := 120;
2069: OPEN p_blanketAndQuoteHdrs_csr FOR
2070: SELECT distinct p.contract_id po_header_id, p.price_type, p.org_id
2071: FROM icx_cat_item_prices p, icx_cat_items_tlp itemtlp,
2072: icx_cat_items_b itemsb, icx_cat_ext_items_tlp exttlp
2073: WHERE p.price_type IN ('BLANKET', 'QUOTATION')
2074: AND p.contract_id >= p_start_po_header_id
2075: AND itemtlp.rt_item_id = p.rt_item_id

Line 2116: FROM icx_cat_item_prices p, icx_cat_items_tlp itemtlp,

2112: p.inventory_item_id, p.org_id,
2113: DECODE(itemtlp.supplier_part_auxid, '##NULL##', null, itemtlp.supplier_part_auxid),
2114: itemsb.catalog_name, itemtlp.primary_category_id,
2115: getPOAttrValuesTLPAction(p.contract_line_id, '-2' ,-2, p.org_id, itemtlp.language)
2116: FROM icx_cat_item_prices p, icx_cat_items_tlp itemtlp,
2117: icx_cat_items_b itemsb, po_headers_interface phi
2118: WHERE p.price_type IN ('BLANKET', 'QUOTATION')
2119: AND p.contract_line_id >= p_start_po_line_id
2120: AND itemtlp.rt_item_id = p.rt_item_id

Line 2134: FROM icx_cat_item_prices p, icx_cat_items_tlp itemtlp,

2130: p.inventory_item_id, p.org_id,
2131: DECODE(itemtlp.supplier_part_auxid, '##NULL##', null, itemtlp.supplier_part_auxid),
2132: itemsb.catalog_name, itemtlp.primary_category_id,
2133: getPOAttrValuesTLPAction(p.contract_line_id, '-2' ,-2, p.org_id, itemtlp.language)
2134: FROM icx_cat_item_prices p, icx_cat_items_tlp itemtlp,
2135: icx_cat_items_b itemsb, icx_cat_ext_items_tlp exttlp, po_headers_interface phi
2136: WHERE p.price_type IN ('BLANKET', 'QUOTATION')
2137: AND p.contract_line_id >= p_start_po_line_id
2138: AND itemtlp.rt_item_id = p.rt_item_id

Line 2492: FROM icx_cat_item_prices p

2488: l_err_loc := 100;
2489: IF (g_extract_last_run_date IS NULL) THEN
2490: OPEN p_reqTemplateHdrs_csr FOR
2491: SELECT distinct p.template_id, p.org_id
2492: FROM icx_cat_item_prices p
2493: WHERE p.price_type IN ('TEMPLATE', 'INTERNAL_TEMPLATE')
2494: AND p.template_id >= p_start_template_id
2495: ORDER BY p.template_id;
2496: ELSE

Line 2500: FROM icx_cat_item_prices p, icx_cat_items_tlp itemtlp,

2496: ELSE
2497: l_err_loc := 200;
2498: OPEN p_reqTemplateHdrs_csr FOR
2499: SELECT distinct p.template_id, p.org_id
2500: FROM icx_cat_item_prices p, icx_cat_items_tlp itemtlp,
2501: icx_cat_items_b itemsb, icx_cat_ext_items_tlp exttlp
2502: WHERE p.price_type IN ('TEMPLATE', 'INTERNAL_TEMPLATE')
2503: AND p.template_id >= p_start_template_id
2504: AND itemtlp.rt_item_id = p.rt_item_id

Line 2542: FROM icx_cat_item_prices p, icx_cat_items_tlp itemtlp,

2538: p.inventory_item_id, p.org_id,
2539: DECODE(itemtlp.supplier_part_auxid, '##NULL##', null, itemtlp.supplier_part_auxid),
2540: itemsb.catalog_name, itemtlp.primary_category_id,
2541: getPOAttrValuesTLPAction(-2, p.template_id, p.template_line_id, p.org_id, itemtlp.language)
2542: FROM icx_cat_item_prices p, icx_cat_items_tlp itemtlp,
2543: icx_cat_items_b itemsb, po_headers_interface phi
2544: WHERE p.price_type IN ('TEMPLATE', 'INTERNAL_TEMPLATE')
2545: AND p.rt_item_id >= p_start_rt_item_id
2546: AND itemtlp.rt_item_id = p.rt_item_id

Line 2561: FROM icx_cat_item_prices p, icx_cat_items_tlp itemtlp,

2557: p.inventory_item_id, p.org_id,
2558: DECODE(itemtlp.supplier_part_auxid, '##NULL##', null, itemtlp.supplier_part_auxid),
2559: itemsb.catalog_name, itemtlp.primary_category_id,
2560: getPOAttrValuesTLPAction(-2, p.template_id, p.template_line_id, p.org_id, itemtlp.language)
2561: FROM icx_cat_item_prices p, icx_cat_items_tlp itemtlp,
2562: icx_cat_items_b itemsb, icx_cat_ext_items_tlp exttlp, po_headers_interface phi
2563: WHERE p.price_type IN ('TEMPLATE', 'INTERNAL_TEMPLATE')
2564: AND p.rt_item_id >= p_start_rt_item_id
2565: AND itemtlp.rt_item_id = p.rt_item_id

Line 2611: l_start_template_id icx_cat_item_prices.template_id%TYPE;

2607:
2608: l_api_name CONSTANT VARCHAR2(30) := 'processReqTemplates';
2609: l_err_loc PLS_INTEGER;
2610: l_err_string VARCHAR2(4000);
2611: l_start_template_id icx_cat_item_prices.template_id%TYPE;
2612: l_start_rt_item_id NUMBER;
2613: l_batch_count PLS_INTEGER;
2614: l_prev_rt_item_id NUMBER;
2615: l_interface_header_id NUMBER;

Line 2952: FROM icx_cat_item_prices price,

2948: OPEN p_contractAutoSourcing_csr FOR
2949: SELECT NVL(price.org_id, -2), NVL(itemtlp.supplier_id, -2), NVL(price.supplier_site_id, -2),
2950: NVL(price.currency, '-2'), NVL(price.contract_id, -2) contract_id,
2951: NVL(map.external_source_key, '-2') po_category_id
2952: FROM icx_cat_item_prices price,
2953: icx_cat_items_tlp itemtlp,
2954: icx_por_category_order_map map
2955: WHERE price.price_type = 'BULKLOAD'
2956: AND price.rt_item_id = itemtlp.rt_item_id

Line 2958: FROM icx_cat_item_prices priceIn

2954: icx_por_category_order_map map
2955: WHERE price.price_type = 'BULKLOAD'
2956: AND price.rt_item_id = itemtlp.rt_item_id
2957: AND NOT EXISTS (SELECT 'extracted price'
2958: FROM icx_cat_item_prices priceIn
2959: WHERE priceIn.rt_item_id = price.rt_item_id
2960: AND priceIn.price_type IN ('BLANKET', 'GLOBAL_AGREEMENT', 'QUOTATION',
2961: 'INTERNAL_TEMPLATE', 'TEMPLATE', 'ASL'))
2962: AND itemtlp.primary_category_id = map.rt_category_id (+)

Line 2972: FROM icx_cat_item_prices price,

2968: OPEN p_contractAutoSourcing_csr FOR
2969: SELECT NVL(price.org_id, -2), NVL(itemtlp.supplier_id, -2), NVL(price.supplier_site_id, -2),
2970: NVL(price.currency, '-2'), NVL(price.contract_id, -2) contract_id,
2971: NVL(map.external_source_key, '-2') po_category_id
2972: FROM icx_cat_item_prices price,
2973: icx_cat_items_tlp itemtlp,
2974: icx_por_category_order_map map,
2975: icx_cat_items_b itemb,
2976: icx_cat_ext_items_tlp extitemtlp,

Line 2981: FROM icx_cat_item_prices priceIn

2977: icx_cat_r12_upgrade upg
2978: WHERE price.price_type = 'BULKLOAD'
2979: AND price.rt_item_id = itemtlp.rt_item_id
2980: AND NOT EXISTS (SELECT 'extracted price'
2981: FROM icx_cat_item_prices priceIn
2982: WHERE priceIn.rt_item_id = price.rt_item_id
2983: AND priceIn.price_type IN ('BLANKET', 'GLOBAL_AGREEMENT', 'QUOTATION',
2984: 'INTERNAL_TEMPLATE', 'TEMPLATE', 'ASL'))
2985: AND itemtlp.primary_category_id = map.rt_category_id (+)

Line 3274: FROM icx_cat_item_prices price, icx_cat_items_tlp itemtlp, icx_cat_items_b itemsb,

3270: DECODE(itemtlp.supplier_part_auxid, '##NULL##', null, itemtlp.supplier_part_auxid),
3271: SUBSTRB(itemtlp.description, 1, 240) description, itemsb.catalog_name,
3272: upg.po_interface_header_id, upg.created_language, upg.po_interface_line_id,
3273: price.price_type, itemtlp.primary_category_name
3274: FROM icx_cat_item_prices price, icx_cat_items_tlp itemtlp, icx_cat_items_b itemsb,
3275: icx_por_category_order_map map, icx_cat_r12_upg_autosource src,
3276: icx_cat_r12_upgrade upg
3277: WHERE price.price_type = 'BULKLOAD'
3278: AND price.rt_item_id = itemtlp.rt_item_id

Line 3281: FROM icx_cat_item_prices priceIn

3277: WHERE price.price_type = 'BULKLOAD'
3278: AND price.rt_item_id = itemtlp.rt_item_id
3279: AND price.rt_item_id = itemsb.rt_item_id
3280: AND NOT EXISTS (SELECT 'extracted price'
3281: FROM icx_cat_item_prices priceIn
3282: WHERE priceIn.rt_item_id = price.rt_item_id
3283: AND priceIn.price_type IN ('BLANKET', 'GLOBAL_AGREEMENT', 'QUOTATION',
3284: 'INTERNAL_TEMPLATE', 'TEMPLATE', 'ASL'))
3285: AND itemtlp.primary_category_id = map.rt_category_id (+)

Line 3311: FROM icx_cat_item_prices price, icx_cat_items_tlp itemtlp, icx_cat_items_b itemsb,

3307: DECODE(itemtlp.supplier_part_auxid, '##NULL##', null, itemtlp.supplier_part_auxid),
3308: SUBSTRB(itemtlp.description, 1, 240) description, itemsb.catalog_name,
3309: upg.po_interface_header_id, upg.created_language, upg.po_interface_line_id,
3310: price.price_type, itemtlp.primary_category_name
3311: FROM icx_cat_item_prices price, icx_cat_items_tlp itemtlp, icx_cat_items_b itemsb,
3312: icx_por_category_order_map map, icx_cat_r12_upgrade upg
3313: WHERE price.price_type = 'CONTRACT'
3314: AND price.rt_item_id = itemtlp.rt_item_id
3315: AND price.rt_item_id = itemsb.rt_item_id

Line 3317: FROM icx_cat_item_prices priceIn

3313: WHERE price.price_type = 'CONTRACT'
3314: AND price.rt_item_id = itemtlp.rt_item_id
3315: AND price.rt_item_id = itemsb.rt_item_id
3316: AND NOT EXISTS (SELECT 'extracted price'
3317: FROM icx_cat_item_prices priceIn
3318: WHERE priceIn.rt_item_id = price.rt_item_id
3319: AND priceIn.price_type IN ('BLANKET', 'GLOBAL_AGREEMENT', 'QUOTATION',
3320: 'INTERNAL_TEMPLATE', 'TEMPLATE', 'ASL'))
3321: AND itemtlp.primary_category_id = map.rt_category_id (+)

Line 3730: FROM icx_cat_item_prices price, icx_cat_items_tlp itemtlp, icx_cat_items_b itemsb,

3726: SUBSTRB(itemtlp.supplier_part_num, 1, 25) supplier_part_num,
3727: DECODE(itemtlp.supplier_part_auxid, '##NULL##', null, itemtlp.supplier_part_auxid),
3728: SUBSTRB(itemtlp.description, 1, 240) description,
3729: itemsb.catalog_name, price.price_type, itemtlp.primary_category_name
3730: FROM icx_cat_item_prices price, icx_cat_items_tlp itemtlp, icx_cat_items_b itemsb,
3731: icx_por_category_order_map map, icx_cat_r12_upg_autosource src
3732: WHERE price.price_type = 'BULKLOAD'
3733: AND price.rt_item_id = itemtlp.rt_item_id
3734: AND price.rt_item_id = itemsb.rt_item_id

Line 3736: FROM icx_cat_item_prices priceIn

3732: WHERE price.price_type = 'BULKLOAD'
3733: AND price.rt_item_id = itemtlp.rt_item_id
3734: AND price.rt_item_id = itemsb.rt_item_id
3735: AND NOT EXISTS (SELECT 'extracted price'
3736: FROM icx_cat_item_prices priceIn
3737: WHERE priceIn.rt_item_id = price.rt_item_id
3738: AND priceIn.price_type IN ('BLANKET', 'GLOBAL_AGREEMENT', 'QUOTATION',
3739: 'INTERNAL_TEMPLATE', 'TEMPLATE', 'ASL'))
3740: AND itemtlp.primary_category_id = map.rt_category_id (+)

Line 3761: FROM icx_cat_item_prices price, icx_cat_items_tlp itemtlp, icx_cat_items_b itemsb,

3757: SUBSTRB(itemtlp.supplier_part_num, 1, 25) supplier_part_num,
3758: DECODE(itemtlp.supplier_part_auxid, '##NULL##', null, itemtlp.supplier_part_auxid),
3759: SUBSTRB(itemtlp.description, 1, 240) description,
3760: itemsb.catalog_name, price.price_type, itemtlp.primary_category_name
3761: FROM icx_cat_item_prices price, icx_cat_items_tlp itemtlp, icx_cat_items_b itemsb,
3762: icx_por_category_order_map map
3763: WHERE price.price_type = 'CONTRACT'
3764: AND price.rt_item_id = itemtlp.rt_item_id
3765: AND price.rt_item_id = itemsb.rt_item_id

Line 3767: FROM icx_cat_item_prices priceIn

3763: WHERE price.price_type = 'CONTRACT'
3764: AND price.rt_item_id = itemtlp.rt_item_id
3765: AND price.rt_item_id = itemsb.rt_item_id
3766: AND NOT EXISTS (SELECT 'extracted price'
3767: FROM icx_cat_item_prices priceIn
3768: WHERE priceIn.rt_item_id = price.rt_item_id
3769: AND priceIn.price_type IN ('BLANKET', 'GLOBAL_AGREEMENT', 'QUOTATION',
3770: 'INTERNAL_TEMPLATE', 'TEMPLATE', 'ASL'))
3771: AND itemtlp.primary_category_id = map.rt_category_id (+)

Line 4106: FROM icx_cat_r12_upg_autosource src, icx_cat_item_prices price,

4102: SELECT src.org_id org_id, src.supplier_id supplier_id,
4103: src.supplier_site_id supplier_site_id, src.currency currency,
4104: src.contract_id gbpa_cpa_reference,
4105: itemtlp.language language
4106: FROM icx_cat_r12_upg_autosource src, icx_cat_item_prices price,
4107: icx_cat_items_tlp itemtlp, icx_por_category_order_map map
4108: WHERE price.price_type = 'BULKLOAD'
4109: AND price.rt_item_id = itemtlp.rt_item_id
4110: AND NOT EXISTS (SELECT 'extracted price'

Line 4111: FROM icx_cat_item_prices priceIn

4107: icx_cat_items_tlp itemtlp, icx_por_category_order_map map
4108: WHERE price.price_type = 'BULKLOAD'
4109: AND price.rt_item_id = itemtlp.rt_item_id
4110: AND NOT EXISTS (SELECT 'extracted price'
4111: FROM icx_cat_item_prices priceIn
4112: WHERE priceIn.rt_item_id = price.rt_item_id
4113: AND priceIn.price_type IN ('BLANKET', 'GLOBAL_AGREEMENT', 'QUOTATION',
4114: 'INTERNAL_TEMPLATE', 'TEMPLATE', 'ASL'))
4115: AND itemtlp.primary_category_id = map.rt_category_id (+)

Line 4127: FROM icx_cat_item_prices price, icx_cat_items_tlp itemtlp

4123: SELECT NVL(itemtlp.org_id, -2) org_id, NVL(itemtlp.supplier_id, -2) supplier_id,
4124: NVL(price.supplier_site_id, -2) supplier_site_id, NVL(price.currency, '-2') currency,
4125: price.contract_id gbpa_cpa_reference,
4126: itemtlp.language language
4127: FROM icx_cat_item_prices price, icx_cat_items_tlp itemtlp
4128: WHERE price.price_type = 'CONTRACT'
4129: AND price.rt_item_id = itemtlp.rt_item_id
4130: AND NOT EXISTS (SELECT 'extracted price'
4131: FROM icx_cat_item_prices priceIn

Line 4131: FROM icx_cat_item_prices priceIn

4127: FROM icx_cat_item_prices price, icx_cat_items_tlp itemtlp
4128: WHERE price.price_type = 'CONTRACT'
4129: AND price.rt_item_id = itemtlp.rt_item_id
4130: AND NOT EXISTS (SELECT 'extracted price'
4131: FROM icx_cat_item_prices priceIn
4132: WHERE priceIn.rt_item_id = price.rt_item_id
4133: AND priceIn.price_type IN ('BLANKET', 'GLOBAL_AGREEMENT', 'QUOTATION',
4134: 'INTERNAL_TEMPLATE', 'TEMPLATE', 'ASL'))
4135: ) doc

Line 4159: l_prev_currency icx_cat_item_prices.currency%TYPE;

4155: l_err_loc PLS_INTEGER;
4156: l_prev_org_id NUMBER;
4157: l_prev_supplier_id NUMBER;
4158: l_prev_supplier_site_id NUMBER;
4159: l_prev_currency icx_cat_item_prices.currency%TYPE;
4160: l_prev_contract_id NUMBER;
4161: l_interface_header_id NUMBER;
4162: l_start_date DATE;
4163: l_end_date DATE;

Line 4364: FROM icx_cat_r12_upg_autosource src, icx_cat_item_prices price,

4360: upg.po_header_id, upg.po_line_id, upg.created_language,
4361: upg.po_category_id old_po_catgegory_id,
4362: DECODE(attr.ATTRIBUTE_VALUES_TLP_ID, NULL, 'ADD', 'UPDATE') attr_val_tlp_action,
4363: price.price_type, itemtlp.primary_category_name
4364: FROM icx_cat_r12_upg_autosource src, icx_cat_item_prices price,
4365: icx_cat_items_tlp itemtlp, icx_por_category_order_map map,
4366: icx_cat_items_b itemb, icx_cat_ext_items_tlp extitemtlp,
4367: icx_cat_r12_upgrade upg, po_attribute_values_tlp attr
4368: WHERE price.price_type = 'BULKLOAD'

Line 4371: FROM icx_cat_item_prices priceIn

4367: icx_cat_r12_upgrade upg, po_attribute_values_tlp attr
4368: WHERE price.price_type = 'BULKLOAD'
4369: AND price.rt_item_id = itemtlp.rt_item_id
4370: AND NOT EXISTS (SELECT 'extracted price'
4371: FROM icx_cat_item_prices priceIn
4372: WHERE priceIn.rt_item_id = price.rt_item_id
4373: AND priceIn.price_type IN ('BLANKET', 'GLOBAL_AGREEMENT', 'QUOTATION',
4374: 'INTERNAL_TEMPLATE', 'TEMPLATE', 'ASL'))
4375: AND itemtlp.primary_category_id = map.rt_category_id (+)

Line 4421: FROM icx_cat_item_prices price, icx_cat_items_tlp itemtlp,

4417: upg.po_header_id, upg.po_line_id, upg.created_language,
4418: upg.po_category_id old_po_catgegory_id,
4419: DECODE(attr.ATTRIBUTE_VALUES_TLP_ID, NULL, 'ADD', 'UPDATE') attr_val_tlp_action,
4420: price.price_type, itemtlp.primary_category_name
4421: FROM icx_cat_item_prices price, icx_cat_items_tlp itemtlp,
4422: icx_por_category_order_map map,
4423: icx_cat_items_b itemb, icx_cat_ext_items_tlp extitemtlp,
4424: icx_cat_r12_upgrade upg, po_attribute_values_tlp attr
4425: WHERE price.price_type = 'CONTRACT'

Line 4428: FROM icx_cat_item_prices priceIn

4424: icx_cat_r12_upgrade upg, po_attribute_values_tlp attr
4425: WHERE price.price_type = 'CONTRACT'
4426: AND price.rt_item_id = itemtlp.rt_item_id
4427: AND NOT EXISTS (SELECT 'extracted price'
4428: FROM icx_cat_item_prices priceIn
4429: WHERE priceIn.rt_item_id = price.rt_item_id
4430: AND priceIn.price_type IN ('BLANKET', 'GLOBAL_AGREEMENT', 'QUOTATION',
4431: 'INTERNAL_TEMPLATE', 'TEMPLATE', 'ASL'))
4432: AND itemtlp.primary_category_id = map.rt_category_id (+)

Line 5167: FROM icx_cat_r12_upg_autosource src, icx_cat_item_prices price,

5163: itemtlp.language language,
5164: upg.po_interface_header_id,
5165: upg.po_header_id, upg.created_language,
5166: nvl(upg.cpa_reference, -2) upg_cpa_reference
5167: FROM icx_cat_r12_upg_autosource src, icx_cat_item_prices price,
5168: icx_cat_items_tlp itemtlp, icx_por_category_order_map map,
5169: icx_cat_items_b itemb, icx_cat_ext_items_tlp extitemtlp,
5170: icx_cat_r12_upgrade upg
5171: WHERE price.price_type = 'BULKLOAD'

Line 5174: FROM icx_cat_item_prices priceIn

5170: icx_cat_r12_upgrade upg
5171: WHERE price.price_type = 'BULKLOAD'
5172: AND price.rt_item_id = itemtlp.rt_item_id
5173: AND NOT EXISTS (SELECT 'extracted price'
5174: FROM icx_cat_item_prices priceIn
5175: WHERE priceIn.rt_item_id = price.rt_item_id
5176: AND priceIn.price_type IN ('BLANKET', 'GLOBAL_AGREEMENT', 'QUOTATION',
5177: 'INTERNAL_TEMPLATE', 'TEMPLATE', 'ASL'))
5178: AND itemtlp.primary_category_id = map.rt_category_id (+)

Line 5208: FROM icx_cat_item_prices price, icx_cat_items_tlp itemtlp,

5204: itemtlp.language language,
5205: upg.po_interface_header_id,
5206: upg.po_header_id, upg.created_language,
5207: nvl(upg.cpa_reference, -2) upg_cpa_reference
5208: FROM icx_cat_item_prices price, icx_cat_items_tlp itemtlp,
5209: icx_cat_items_b itemb, icx_cat_ext_items_tlp extitemtlp,
5210: icx_cat_r12_upgrade upg
5211: WHERE price.price_type = 'CONTRACT'
5212: AND price.rt_item_id = itemtlp.rt_item_id

Line 5214: FROM icx_cat_item_prices priceIn

5210: icx_cat_r12_upgrade upg
5211: WHERE price.price_type = 'CONTRACT'
5212: AND price.rt_item_id = itemtlp.rt_item_id
5213: AND NOT EXISTS (SELECT 'extracted price'
5214: FROM icx_cat_item_prices priceIn
5215: WHERE priceIn.rt_item_id = price.rt_item_id
5216: AND priceIn.price_type IN ('BLANKET', 'GLOBAL_AGREEMENT', 'QUOTATION',
5217: 'INTERNAL_TEMPLATE', 'TEMPLATE', 'ASL'))
5218: AND price.rt_item_id = itemb.rt_item_id

Line 5365: FROM icx_cat_items_b itemsB, icx_cat_item_prices prices

5361: SELECT rt_item_id, po_interface_header_id, po_interface_line_id,
5362: upg.po_header_id, po_line_id, ph.org_id
5363: FROM icx_cat_r12_upgrade upg, po_headers_all ph
5364: WHERE NOT EXISTS (SELECT 'x'
5365: FROM icx_cat_items_b itemsB, icx_cat_item_prices prices
5366: WHERE itemsB.rt_item_id = prices.rt_item_id
5367: AND upg.rt_item_id = prices.rt_item_id
5368: AND upg.supplier_site_id = prices.supplier_site_id
5369: AND upg.currency = prices.currency

Line 5795: icx_cat_ext_items_tlp and icx_cat_item_prices

5791: 3. Check for item updated/translation added
5792: Note: Steps 1, 2 and 3 will be done together using the following approach:
5793: a) Outer join with icx_cat_r12_upgrade
5794: b) Check for last_update_date > g_bulk_last_run_date in icx_cat_items_b, icx_cat_items_tlp,
5795: icx_cat_ext_items_tlp and icx_cat_item_prices
5796: 4. Check for items deleted i.e. rt_item_id exists in icx_cat_r12_upgrade but not in icx_cat_items_b
5797: 5. Check for price deleted i.e. price_rowid exists in icx_cat_r12_upgrade but not in icx_cat_items_b
5798: 6. Check for any pricing hdr attribute (i.e. supplier_site_id, currency, contract_id) update after running pre-upgrade.
5799: Note: Steps 4, 5 and 6 will be done together using the following approach:

Line 5800: a) Get all the records from icx_cat_r12_upgrade that don't exist in icx_cat_items_b and icx_cat_item_prices

5796: 4. Check for items deleted i.e. rt_item_id exists in icx_cat_r12_upgrade but not in icx_cat_items_b
5797: 5. Check for price deleted i.e. price_rowid exists in icx_cat_r12_upgrade but not in icx_cat_items_b
5798: 6. Check for any pricing hdr attribute (i.e. supplier_site_id, currency, contract_id) update after running pre-upgrade.
5799: Note: Steps 4, 5 and 6 will be done together using the following approach:
5800: a) Get all the records from icx_cat_r12_upgrade that don't exist in icx_cat_items_b and icx_cat_item_prices
5801: based on rt_item_id, supplier_site_id, currency, contract_id
5802: 7. Check for items that have errors i.e. the ones that were not migrated into po tables due to validation errors,
5803: These will have po_interface_header_id and po_interface_line_id populated but will have null po_header_id and po_line_id
5804: Assumptions: Translations cannot be deleted.

Line 5831: FROM icx_cat_item_prices

5827: PROCEDURE migrateBulkloadItems
5828: IS
5829: CURSOR cleanUpContractIdsCsr(p_rt_item_id NUMBER) IS
5830: SELECT rowid, rt_item_id
5831: FROM icx_cat_item_prices
5832: WHERE rt_item_id >= p_rt_item_id
5833: AND price_type in ('BULKLOAD', 'CONTRACT')
5834: AND contract_id IS NULL;
5835:

Line 5877: UPDATE icx_cat_item_prices

5873: l_start_rt_item_id := l_rt_item_id_tbl(l_rt_item_id_tbl.COUNT);
5874:
5875: l_err_loc := 180;
5876: FORALL i IN 1..l_rowid_tbl.COUNT
5877: UPDATE icx_cat_item_prices
5878: SET contract_id = -2
5879: WHERE rowid = l_rowid_tbl(i);
5880:
5881: l_err_loc := 185;

Line 5886: 'No: of rows updated in icx_cat_item_prices:' ||SQL%ROWCOUNT);

5882: IF (l_rowid_tbl.COUNT > 0) THEN
5883: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5884: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
5885: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5886: 'No: of rows updated in icx_cat_item_prices:' ||SQL%ROWCOUNT);
5887: END IF;
5888: END IF;
5889:
5890: l_err_loc := 190;

Line 6358: icx_cat_item_prices price,

6354: -- for items that were bulkloaded in prior releases.
6355: CURSOR updSrcDocIdsInOldFavLinesCsr IS
6356: SELECT fav.rowid, upg.po_line_id
6357: FROM por_favorite_list_lines fav,
6358: icx_cat_item_prices price,
6359: icx_cat_r12_upgrade upg
6360: WHERE fav.rt_item_id IS NOT NULL
6361: AND fav.price_list_id IS NOT NULL
6362: AND fav.source_doc_line_id IS NULL