APPS.ICX_POR_ITEM_UPLOAD dependencies on ICX_CAT_ITEMS_B

Line 1252: -- ICX_CAT_ITEMS_B

1248: v_catid PLS_INTEGER;
1249: v_count NUMBER;
1250: BEGIN
1251:
1252: -- ICX_CAT_ITEMS_B
1253: FORALL i in 1..gRowIds.COUNT
1254: INSERT into icx_cat_items_b(rt_item_id, org_id, supplier_id,supplier,
1255: supplier_part_num, supplier_part_auxid, catalog_name, --Bug#2611529
1256: extractor_updated_flag, request_id, created_by,

Line 1254: INSERT into icx_cat_items_b(rt_item_id, org_id, supplier_id,supplier,

1250: BEGIN
1251:
1252: -- ICX_CAT_ITEMS_B
1253: FORALL i in 1..gRowIds.COUNT
1254: INSERT into icx_cat_items_b(rt_item_id, org_id, supplier_id,supplier,
1255: supplier_part_num, supplier_part_auxid, catalog_name, --Bug#2611529
1256: extractor_updated_flag, request_id, created_by,
1257: creation_date, last_updated_by, last_update_login, last_update_date, OBJECT_VERSION_NUMBER)
1258: SELECT gItemIds(i), it.org_id, it.supplier_id, it.supplier,

Line 1706: -- ICX_CAT_ITEMS_B

1702: v_sequence PLS_INTEGER := 10001;
1703: xErrLoc PLS_INTEGER := 100;
1704: BEGIN
1705:
1706: -- ICX_CAT_ITEMS_B
1707: -- Update the catalog name, job#, object version#, last_update_date
1708: xErrLoc := 10;
1709: FORALL i in 1..gCurrentItemIds.COUNT
1710: UPDATE icx_cat_items_b

Line 1710: UPDATE icx_cat_items_b

1706: -- ICX_CAT_ITEMS_B
1707: -- Update the catalog name, job#, object version#, last_update_date
1708: xErrLoc := 10;
1709: FORALL i in 1..gCurrentItemIds.COUNT
1710: UPDATE icx_cat_items_b
1711: SET catalog_name = gCatalogName,
1712: last_updated_by = gUserId,
1713: last_update_login = gUserLogin,
1714: last_update_date = sysdate,

Line 1913: -- ICX_CAT_ITEMS_B

1909: v_action VARCHAR2(10) := 'DELETE';
1910: xErrLoc PLS_INTEGER := 100;
1911: BEGIN
1912:
1913: -- ICX_CAT_ITEMS_B
1914: FORALL i in 1..gRowIds.COUNT
1915: DELETE from icx_cat_items_b
1916: WHERE rt_item_id = gItemIds(i)
1917: AND v_action = gSystemActions(i);

Line 1915: DELETE from icx_cat_items_b

1911: BEGIN
1912:
1913: -- ICX_CAT_ITEMS_B
1914: FORALL i in 1..gRowIds.COUNT
1915: DELETE from icx_cat_items_b
1916: WHERE rt_item_id = gItemIds(i)
1917: AND v_action = gSystemActions(i);
1918:
1919: xErrLoc := 200;

Line 3555: icx_cat_items_b i

3551: it.price_list_id,
3552: it.supplier_site_id,
3553: it.unit_of_measure
3554: FROM ICX_CAT_PRICES_GT it,
3555: icx_cat_items_b i
3556: WHERE it.supplier = i.supplier (+)
3557: AND it.supplier_part_num = i.supplier_part_num (+)
3558: AND it.supplier_part_auxid = i.supplier_part_auxid (+) -- Bug#2611529
3559: AND it.org_id = i.org_id(+)

Line 3944: icx_cat_items_b i, --Bug#2714487: dont join with category_items

3940: it.unit_price,
3941: it.unit_of_measure
3942: ,it.system_action
3943: FROM ICX_CAT_ITEMS_GT it,
3944: icx_cat_items_b i, --Bug#2714487: dont join with category_items
3945: icx_cat_items_tlp tl
3946: WHERE it.supplier = i.supplier (+)
3947: AND it.supplier_part_num = i.supplier_part_num (+)
3948: AND it.supplier_part_auxid = i.supplier_part_auxid (+) --Bug#2611529