DBA Data[Home] [Help]

APPS.ICX_ITEM_DIAG_PVT dependencies on ICX_CAT_ITEMS_CTX_DTLS_TLP

Line 493: FROM icx_cat_items_ctx_dtls_tlp

489: cursor dtls(j number) is
490: SELECT inventory_item_id ,po_line_id ,req_template_name
491: ,req_template_line_num ,org_id ,language
492: ,SEQUENCE , htf.escape_sc(CTX_DESC)
493: FROM icx_cat_items_ctx_dtls_tlp
494: WHERE inventory_item_id =g_source_ids(j)
495: AND org_id = nvl(g_org_id,org_id)
496: order by po_line_id ,req_template_name,language , sequence;
497:

Line 832: elsif p_table_name = 'ICX_CAT_ITEMS_CTX_DTLS_TLP' then

828: p_col_num :=18;
829: p_row_num:=p_row_num-1;
830: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
831:
832: elsif p_table_name = 'ICX_CAT_ITEMS_CTX_DTLS_TLP' then
833: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'7');
834: p_col_val(1):='INVENTORY_ITEM_ID';
835: p_col_val(2):='PO_LINE_ID';
836: p_col_val(3):='REQ_TEMPLATE_NAME';