APPS.ICX_ITEM_DIAG_PVT dependencies on ICX_CAT_ITEMS_CTX_HDRS_TLP

Line 484: FROM icx_cat_items_ctx_hdrs_tlp

480: ,unit_price ,unit_meas_lookup_code ,line_type_id
481: ,document_number ,item_type ,supplier_site_id
482: ,supplier_id ,po_category_id ,ip_category_id
483: ,ip_category_name ,source_type , decode(ip_category_id,-2,'May not be searchable',decode(supplier_id,-2,'May not be searchable',null)) WARNING
484: FROM icx_cat_items_ctx_hdrs_tlp
485: WHERE inventory_item_id =g_source_ids(j)
486: AND org_id = nvl(g_org_id,org_id)
487: order by language,source_type;
488:

Line 788: elsif p_table_name = 'ICX_CAT_ITEMS_CTX_HDRS_TLP' then

784: p_col_num :=5;
785: p_row_num:=p_row_num-1;
786: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
787:
788: elsif p_table_name = 'ICX_CAT_ITEMS_CTX_HDRS_TLP' then
789: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'6');
790: p_col_val(1):='INVENTORY_ITEM_ID';
791: p_col_val(2):='PO_LINE_ID';
792: p_col_val(3):='REQ_TEMPLATE_NAME';

Line 1158: icx_cat_items_ctx_hdrs_tlp ctx

1154: AND catMap.external_source_key (+) = TO_CHAR(mic.category_id)
1155: AND catMap.external_source (+) = 'Oracle'
1156: ) doc,
1157: icx_cat_categories_tl ic1,
1158: icx_cat_items_ctx_hdrs_tlp ctx
1159: WHERE ic1.key (+) = doc.category_key
1160: AND ic1.type (+) = 2
1161: AND ic1.language (+) = doc.language
1162: AND doc.inventory_item_id = ctx.inventory_item_id (+)

Line 1234: icx_cat_items_ctx_hdrs_tlp record missing.

1230: /*
1231: validation 1 # If CATEGORY_KEY is null , then you need to create shopping category and mapping
1232: programmatically or manually
1233: validation 2 # If CTX_IP_INVENTORY_ITEM_ID is -2 , then you need to reextract the item.
1234: icx_cat_items_ctx_hdrs_tlp record missing.
1235: validation 3 # If CTX_IP_CATEGORY_ID is -2 , then you need to reextract the item.
1236: validation 4 # validate item using api ICX_CAT_UTIL_PVT.is_item_valid_for_search
1237: */
1238: if l_row_val(p_row_num)(10) IS NULL THEN

Line 1406: FROM icx_cat_items_ctx_hdrs_tlp ctx

1402: procedure PO_ATTRIBUTE_VALUES_DATA_FIX is
1403:
1404: CURSOR master_csr IS
1405: SELECT *
1406: FROM icx_cat_items_ctx_hdrs_tlp ctx
1407: WHERE ctx.PO_LINE_ID=-2
1408: AND ctx.REQ_TEMPLATE_NAME='-2'
1409: AND ctx.REQ_TEMPLATE_LINE_NUM = -2
1410: AND ctx.SOURCE_TYPE = 'MASTER_ITEM'

Line 1420: rec_MI icx_cat_items_ctx_hdrs_tlp%ROWTYPE;

1416: AND poav.REQ_TEMPLATE_NAME='-2'
1417: AND poav.REQ_TEMPLATE_LINE_NUM = -2)
1418: ORDER BY INVENTORY_ITEM_ID;
1419:
1420: rec_MI icx_cat_items_ctx_hdrs_tlp%ROWTYPE;
1421: l_organization_id NUMBER;
1422: l_master_organization_id NUMBER;
1423: l_long_description PO_ATTRIBUTE_VALUES_TLP.LONG_DESCRIPTION%TYPE;
1424: l_api_name VARCHAR2(50) := 'PO_ATTRIBUTE_VALUES_DATA_FIX';

Line 1827: icx_cat_items_ctx_hdrs_tlp ctx

1823: AND catMap.external_source_key (+) = TO_CHAR(mic.category_id)
1824: AND catMap.external_source (+) = 'Oracle'
1825: ) doc,
1826: icx_cat_categories_tl ic1,
1827: icx_cat_items_ctx_hdrs_tlp ctx
1828: WHERE ic1.key (+) = doc.category_key
1829: AND ic1.type (+) = 2
1830: AND ic1.language (+) = doc.language
1831: AND doc.inventory_item_id = ctx.inventory_item_id (+)

Line 1908: where po_header_id in ( select distinct pol.po_header_id from po_attribute_values_tlp po , icx_cat_items_ctx_hdrs_tlp ctx, po_lines_all pol

1904: if p_source_type = 'BLANKET' then
1905: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,p_source_type);
1906:
1907: update po_headers_all set last_update_date = sysdate
1908: where po_header_id in ( select distinct pol.po_header_id from po_attribute_values_tlp po , icx_cat_items_ctx_hdrs_tlp ctx, po_lines_all pol
1909: where po.po_line_id=ctx.po_line_id
1910: and po.po_line_id=pol.po_line_id
1911: and ctx.source_type in ('BLANKET','QUOTATION','GLOBAL_BLANKET')
1912: and (po.ip_category_id <> ctx.ip_category_id or pol.unit_price <> ctx.unit_price)