DBA Data[Home] [Help]

APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on ICX_CAT_CATEGORIES_V

Line 4439: FROM icx_cat_categories_v cat

4435: INSERT INTO po_session_gt(key, num1, char1)
4436: SELECT p_key,
4437: p_index_tbl(i),
4438: cat.rt_category_id
4439: FROM icx_cat_categories_v cat
4440: WHERE p_ip_category_tbl(i) IS NOT NULL
4441: AND x_ip_category_id_tbl(i) IS NULL
4442: AND cat.key = p_ip_category_tbl(i);
4443:

Line 4475: FROM icx_cat_categories_v

4471: INSERT INTO po_session_gt(key, num1, char1)
4472: SELECT p_key,
4473: p_index_tbl(i),
4474: rt_category_id
4475: FROM icx_cat_categories_v
4476: WHERE p_ip_category_tbl(i) IS NOT NULL
4477: AND x_ip_category_id_tbl(i) IS NULL
4478: AND category_name = p_ip_category_tbl(i)
4479: AND language = NVL(p_file_line_language_tbl(i),