APPS.ICX_CAT_R12_UPGRADE_PVT dependencies on ICX_CAT_ITEMS_CTX_HDRS_TLP

Line 6421: FROM por_favorite_list_lines fav, icx_cat_items_ctx_hdrs_tlp items

6417: SELECT favorite_list_id, favorite_list_line_id,
6418: fav.source_doc_line_id, fav.template_name,
6419: fav.template_line_num, fav.item_id,
6420: items.source_type, items.language, items.org_id
6421: FROM por_favorite_list_lines fav, icx_cat_items_ctx_hdrs_tlp items
6422: WHERE fav.item_type = 'CATALOG'
6423: AND fav.duplicate_in_r12 IS NULL
6424: AND fav.source_doc_line_id = items.po_line_id
6425: AND fav.template_name = items.req_template_name

Line 6517: l_prev_req_template_name icx_cat_items_ctx_hdrs_tlp.req_template_name%TYPE := '-1';

6513: l_prev_favorite_list_id NUMBER := -1;
6514: l_prev_favorite_list_line_id NUMBER := -1;
6515: l_prev_rt_item_id NUMBER := -1;
6516: l_prev_po_line_id NUMBER := -1;
6517: l_prev_req_template_name icx_cat_items_ctx_hdrs_tlp.req_template_name%TYPE := '-1';
6518: l_prev_req_template_line_num NUMBER := -1;
6519: l_prev_inventory_item_id NUMBER := -1;
6520: l_prev_source_type icx_cat_items_ctx_hdrs_tlp.source_type%TYPE := '-1';
6521: l_dupe_fav_list_index PLS_INTEGER := 0;

Line 6520: l_prev_source_type icx_cat_items_ctx_hdrs_tlp.source_type%TYPE := '-1';

6516: l_prev_po_line_id NUMBER := -1;
6517: l_prev_req_template_name icx_cat_items_ctx_hdrs_tlp.req_template_name%TYPE := '-1';
6518: l_prev_req_template_line_num NUMBER := -1;
6519: l_prev_inventory_item_id NUMBER := -1;
6520: l_prev_source_type icx_cat_items_ctx_hdrs_tlp.source_type%TYPE := '-1';
6521: l_dupe_fav_list_index PLS_INTEGER := 0;
6522: l_fav_list_lines_index PLS_INTEGER := 0;
6523: l_org_id_index PLS_INTEGER := 0;
6524: l_profile_option_id NUMBER;