APPS.ICX_CAT_FPI_UPGRADE dependencies on ICX_POR_ITEMS

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 725: icx_por_items item,

721: TO_NUMBER(NULL) line_type_id,
722: TO_NUMBER(NULL) buyer_id,
723: prl.rowid row_id
724: FROM icx_por_price_list_lines prl,
725: icx_por_items item,
726: po_vendor_sites_all pvs
727: WHERE prl.item_id = p_rt_item_id
728: AND prl.buyer_approval_status = 'APPROVED'
729: AND item.rt_item_id = p_rt_item_id

Line 787: icx_por_items item,

783: TO_NUMBER(NULL) line_type_id,
784: TO_NUMBER(NULL) buyer_id,
785: sub.rowid row_id
786: FROM icx_por_oracle_item_subtable sub,
787: icx_por_items item,
788: mtl_system_items msi
789: WHERE sub.rt_item_id = p_rt_item_id
790: AND sub.orc_template_id is null
791: AND sub.orc_contract_id is null

Line 1161: FROM ICX_POR_ITEMS item

1157: gIExtractorUpdatedFlags(i),
1158: gUpgradeUserId, gUpgradeUserId, sysdate,
1159: gUpgradeUserId, item.creation_date, gUpgradeUserId,
1160: gUpgradeUserId, gUpgradeUserId, sysdate
1161: FROM ICX_POR_ITEMS item
1162: WHERE item.rt_item_id = gIOldRtItemIds(i);
1163:
1164: COMMIT;
1165:

Line 1198: FROM ICX_POR_ITEMS item,

1194: item.A24, item.A25, to_number(item.A26), item.A29,
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)

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:

Line 1455: ICX_POR_ITEMS item

1451: NULL, gUpgradeUserId, gUpgradeUserId, sysdate,
1452: gUpgradeUserId, sub.creation_date, gUpgradePhaseId,
1453: gUpgradeUserId, gUpgradeUserId, sysdate
1454: FROM ICX_POR_ORACLE_ITEM_SUBTABLE sub,
1455: ICX_POR_ITEMS item
1456: WHERE sub.rowid = gEPRowIds(i)
1457: AND item.rt_item_id = sub.rt_item_id;
1458:
1459: COMMIT;

Line 2372: icx_por_items oi

2368: OPEN cMatchRtItemIds FOR
2369: SELECT distinct p.rt_item_id
2370: FROM icx_cat_item_prices p,
2371: icx_cat_items_b i,
2372: icx_por_items oi
2373: WHERE p.price_list_id = favorite.price_list_id
2374: AND p.rt_item_id = i.rt_item_id
2375: AND oi.rt_item_id = favorite.rt_item_id
2376: AND i.supplier = oi.a1

Line 2577: FROM icx_por_items item

2573: xReturnErr VARCHAR2(2000);
2574: CURSOR cAllItems IS
2575: SELECT item.rt_item_id,
2576: getOldPrimaryCategoryId(item.rt_item_id) rt_category_id
2577: FROM icx_por_items item
2578: WHERE NOT EXISTS (SELECT 'already upgraded'
2579: FROM icx_cat_items_b new_item
2580: WHERE item.rt_item_id = new_item.rt_item_id)
2581: AND (EXISTS (SELECT 'extracted price'