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_EXT_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 2072: icx_cat_items_b itemsb, icx_cat_ext_items_tlp exttlp

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
2076: AND itemsb.rt_item_id = p.rt_item_id

Line 2135: icx_cat_items_b itemsb, icx_cat_ext_items_tlp exttlp, po_headers_interface phi

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
2139: AND itemsb.rt_item_id = p.rt_item_id

Line 2501: icx_cat_items_b itemsb, icx_cat_ext_items_tlp exttlp

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
2505: AND itemsb.rt_item_id = p.rt_item_id

Line 2562: icx_cat_items_b itemsb, icx_cat_ext_items_tlp exttlp, po_headers_interface phi

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
2566: AND itemsb.rt_item_id = p.rt_item_id

Line 2976: icx_cat_ext_items_tlp extitemtlp,

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
2978: WHERE price.price_type = 'BULKLOAD'
2979: AND price.rt_item_id = itemtlp.rt_item_id
2980: AND NOT EXISTS (SELECT 'extracted price'

Line 4366: icx_cat_items_b itemb, icx_cat_ext_items_tlp extitemtlp,

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

Line 4423: icx_cat_items_b itemb, icx_cat_ext_items_tlp extitemtlp,

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'
4426: AND price.rt_item_id = itemtlp.rt_item_id
4427: AND NOT EXISTS (SELECT 'extracted price'

Line 5169: icx_cat_items_b itemb, icx_cat_ext_items_tlp extitemtlp,

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

Line 5209: icx_cat_items_b itemb, icx_cat_ext_items_tlp extitemtlp,

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

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: