APPS.ICX_CAT_BUILD_CTX_SQL_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 19

  SELECT searchable, section_tag
  INTO   p_searchable, p_section_tag
  FROM   icx_cat_attributes_tl
  WHERE  key = p_attribute_key
  AND    rownum = 1;

Line: 55

    SELECT attribute_id, key, type,
           section_tag, stored_in_table, stored_in_column
    FROM   icx_cat_attributes_tl
    WHERE  rt_category_id = p_category_id
    AND    language = ( SELECT language_code FROM fnd_languages WHERE installed_flag = 'B')
    AND    searchable = 1
    ORDER BY attribute_id;

Line: 92

  l_attribute_id_tbl.DELETE;

Line: 93

  l_key_tbl.DELETE;

Line: 94

  l_type_tbl.DELETE;

Line: 95

  l_section_tag_tbl.DELETE;

Line: 96

  l_stored_in_table_tbl.DELETE;

Line: 97

  l_stored_in_column_tbl.DELETE;

Line: 295

    'INSERT INTO icx_cat_items_ctx_dtls_tlp ' ||
    '(inventory_item_id, po_line_id, req_template_name, ' ||
    'req_template_line_num, org_id, language, ' ||
    'last_update_login, last_updated_by, last_update_date, ' ||
    'internal_request_id, request_id, created_by, creation_date, ' ||
    'sequence, ctx_desc) ' ||
    'SELECT hdrs.inventory_item_id, hdrs.po_line_id, hdrs.req_template_name, ' ||
    'hdrs.req_template_line_num, hdrs.org_id, hdrs.language, ' ||
    'hdrs.last_update_login, hdrs.last_updated_by, hdrs.last_update_date, ' ||
    'hdrs.internal_request_id, hdrs.request_id, hdrs.created_by, hdrs.creation_date, ' ||
    ':B_sequence, null ';

Line: 309

    'INSERT INTO icx_cat_items_ctx_dtls_tlp ' ||
    '(inventory_item_id, po_line_id, req_template_name, ' ||
    'req_template_line_num, org_id, language, ' ||
    'last_update_login, last_updated_by, last_update_date, ' ||
    'internal_request_id, request_id, created_by, creation_date, ' ||
    'sequence, ctx_desc) ' ||
    'SELECT /*+ LEADING(doc) */ doc.inventory_item_id, doc.po_line_id, doc.req_template_name, ' ||
    'doc.req_template_line_num, doc.org_id, doc.language, ' ||
    'doc.last_update_login, doc.last_updated_by, doc.last_update_date, ' ||
    'doc.internal_request_id, doc.request_id, doc.created_by, doc.creation_date, ' ||
    ':B_sequence, null ';

Line: 427

        ' FROM (SELECT hdrs.inventory_item_id, hdrs.po_line_id, hdrs.req_template_name, ' ||
        '              hdrs.req_template_line_num, hdrs.org_id, hdrs.language, ' ||
        '              hdrs.last_update_login, hdrs.last_updated_by, hdrs.last_update_date, ' ||
        '              hdrs.internal_request_id, hdrs.request_id, hdrs.created_by, ' ||
        '              hdrs.creation_date, fsp.inventory_organization_id ' ||
        '       FROM icx_cat_items_ctx_hdrs_tlp hdrs, financials_system_params_all fsp ' ||
        '       WHERE hdrs.org_id = fsp.org_id (+) ' ||
        '       AND  ' || l_ctxsql_suffixStr ||
        '       ) doc, mtl_system_items_b mi ' ||
        ' WHERE doc.inventory_item_id = mi.inventory_item_id (+) ' ||
        ' AND doc.inventory_organization_id = mi.organization_id (+) ';

Line: 707

          ' FROM (SELECT hdrs.inventory_item_id, hdrs.po_line_id, hdrs.req_template_name, ' ||
          '              hdrs.req_template_line_num, hdrs.org_id, hdrs.language, ' ||
          '              hdrs.last_update_login, hdrs.last_updated_by, hdrs.last_update_date, ' ||
          '              hdrs.internal_request_id, hdrs.request_id, hdrs.created_by, ' ||
          '              hdrs.creation_date, fsp.inventory_organization_id ' ||
          '       FROM icx_cat_items_ctx_hdrs_tlp hdrs, financials_system_params_all fsp ' ||
          '       WHERE hdrs.org_id = fsp.org_id (+) ' ||
          '       AND  ' || l_ctxsql_suffixStr ||
          '       ) doc, mtl_system_items_tl mitl ' ||
          ' WHERE doc.inventory_item_id = mitl.inventory_item_id (+) ' ||
          ' AND doc.language = mitl.language (+) ' ||
          ' AND doc.inventory_organization_id = mitl.organization_id (+) ';