DBA Data[Home] [Help]

APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on ICX_CAT_CATEGORIES_V

Line 5361: FROM icx_cat_categories_v cat

5357: INSERT INTO po_session_gt(key, num1, char1)
5358: SELECT p_key,
5359: p_index_tbl(i),
5360: cat.rt_category_id
5361: FROM icx_cat_categories_v cat
5362: WHERE p_ip_category_tbl(i) IS NOT NULL
5363: AND x_ip_category_id_tbl(i) IS NULL
5364: AND cat.key = p_ip_category_tbl(i);
5365:

Line 5397: FROM icx_cat_categories_v

5393: INSERT INTO po_session_gt(key, num1, char1)
5394: SELECT p_key,
5395: p_index_tbl(i),
5396: rt_category_id
5397: FROM icx_cat_categories_v
5398: WHERE p_ip_category_tbl(i) IS NOT NULL
5399: AND x_ip_category_id_tbl(i) IS NULL
5400: AND category_name = p_ip_category_tbl(i)
5401: AND language = NVL(p_file_line_language_tbl(i),