APPS.ICX_POR_CTX_DESC dependencies on ICX_CAT_ITEM_PRICES

Line 1099: (SELECT distinct org_id FROM icx_cat_item_prices

1095: (rt_item_id,language,sequence,ctx_desc,org_id)
1096: SELECT tl.rt_item_id, tl.language, v_sequence,
1097: to_char(pll.org_id), pll.org_id
1098: FROM icx_cat_items_tlp tl,
1099: (SELECT distinct org_id FROM icx_cat_item_prices
1100: WHERE rt_item_id = vItemIdTab(i)
1101: ) pll
1102: WHERE tl.rowid = vRowIdTab(i);
1103: ELSE

Line 1111: (SELECT distinct org_id FROM icx_cat_item_prices

1107: (rt_item_id,language,sequence,ctx_desc,org_id)
1108: SELECT tl.rt_item_id, tl.language, v_sequence,
1109: to_char(pll.org_id), pll.org_id
1110: FROM icx_cat_items_tlp tl,
1111: (SELECT distinct org_id FROM icx_cat_item_prices
1112: WHERE rt_item_id = vItemIdTab(i)
1113: ) pll
1114: WHERE tl.rt_item_id = vItemIdTab(i)
1115: AND tl.language = vLangTab(i);