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_ITEMS_TLP

Line 1659: FROM icx_cat_items_tlp baseAtt, icx_cat_ext_items_tlp catAtt

1655: catAtt.num_cat_attribute39, catAtt.num_cat_attribute40, catAtt.num_cat_attribute41,
1656: catAtt.num_cat_attribute42, catAtt.num_cat_attribute43, catAtt.num_cat_attribute44,
1657: catAtt.num_cat_attribute45, catAtt.num_cat_attribute46, catAtt.num_cat_attribute47,
1658: catAtt.num_cat_attribute48, catAtt.num_cat_attribute49, catAtt.num_cat_attribute50
1659: FROM icx_cat_items_tlp baseAtt, icx_cat_ext_items_tlp catAtt
1660: WHERE baseAtt.rt_item_id = catAtt.rt_item_id
1661: AND baseAtt.language = catAtt.language
1662: AND baseAtt.rt_item_id = gIAVRtItemIdTbl(i)
1663: AND baseAtt.language = gIAVLanguageTbl(i);

Line 1794: FROM icx_cat_items_tlp baseAtt, icx_cat_ext_items_tlp catAtt

1790: catAtt.tl_text_cat_attribute39, catAtt.tl_text_cat_attribute40, catAtt.tl_text_cat_attribute41,
1791: catAtt.tl_text_cat_attribute42, catAtt.tl_text_cat_attribute43, catAtt.tl_text_cat_attribute44,
1792: catAtt.tl_text_cat_attribute45, catAtt.tl_text_cat_attribute46, catAtt.tl_text_cat_attribute47,
1793: catAtt.tl_text_cat_attribute48, catAtt.tl_text_cat_attribute49, catAtt.tl_text_cat_attribute50
1794: FROM icx_cat_items_tlp baseAtt, icx_cat_ext_items_tlp catAtt
1795: WHERE baseAtt.rt_item_id = catAtt.rt_item_id
1796: AND baseAtt.language = catAtt.language
1797: AND baseAtt.rt_item_id = gIAVTRtItemIdTbl(i)
1798: AND baseAtt.language = gIAVTLanguageTbl(i);

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 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 2953: icx_cat_items_tlp itemtlp,

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
2957: AND NOT EXISTS (SELECT 'extracted price'

Line 2973: icx_cat_items_tlp itemtlp,

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,
2977: icx_cat_r12_upgrade upg

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 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 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 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 4107: icx_cat_items_tlp itemtlp, icx_por_category_order_map map

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'
4111: FROM icx_cat_item_prices priceIn

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 4365: icx_cat_items_tlp itemtlp, icx_por_category_order_map map,

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'
4369: AND price.rt_item_id = itemtlp.rt_item_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 5168: icx_cat_items_tlp itemtlp, icx_por_category_order_map map,

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'
5172: AND price.rt_item_id = itemtlp.rt_item_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 5794: b) Check for last_update_date > g_bulk_last_run_date in icx_cat_items_b, icx_cat_items_tlp,

5790: 2. Check for price added i.e. price_rowid not in icx_cat_r12_upgrade
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.