APPS.ICX_CAT_FPI_UPGRADE dependencies on ICX_POR_ITEMS_TL

Line 481: ' FROM ICX_POR_ITEMS i, ICX_POR_ITEMS_TL tl ' ||

477: gDynSqlBaseAttributes :=
478: 'UPDATE ICX_CAT_ITEMS_TLP tlp ' ||
479: 'SET (' || xUpdateColumns || ') = ' ||
480: '(SELECT ' || xSelectColumns ||
481: ' FROM ICX_POR_ITEMS i, ICX_POR_ITEMS_TL tl ' ||
482: ' WHERE i.rt_item_id = :old_rt_item_id ' ||
483: ' AND i.rt_item_id = tl.rt_item_id ' ||
484: ' AND tlp.language = tl.language) ' ||
485: 'WHERE tlp.rt_item_id = :new_rt_item_id';

Line 1199: ICX_POR_ITEMS_TL tl,

1195: NULL, gUpgradeUserId, gUpgradeUserId, sysdate,
1196: gUpgradeUserId, tl.creation_date, gUpgradeUserId,
1197: gUpgradeUserId, gUpgradeUserId, sysdate
1198: FROM ICX_POR_ITEMS item,
1199: ICX_POR_ITEMS_TL tl,
1200: ICX_POR_CATEGORY_ITEMS ci,
1201: ICX_POR_CATEGORIES_TL cat
1202: WHERE item.rt_item_id = gIOldRtItemIds(i)
1203: AND item.rt_item_id = tl.rt_item_id

Line 1266: FROM ICX_POR_ITEMS_TL tl

1262: gIRtCategoryIds(i), NULL,
1263: gUpgradeUserId, gUpgradeUserId, sysdate,
1264: gUpgradeUserId, sysdate, gUpgradeUserId,
1265: gUpgradeUserId, gUpgradeUserId, sysdate
1266: FROM ICX_POR_ITEMS_TL tl
1267: WHERE tl.rt_item_id = gIOldRtItemIds(i);
1268:
1269: COMMIT;
1270: