APPS.ICX_POR_EXT_PURGE dependencies on ICX_CAT_ITEMS_B

Line 413: FROM icx_cat_items_b i,

409: FROM icx_cat_categories_tl cat
410: WHERE cat.title = 'Oracle'
411: AND cat.language = ICX_POR_EXTRACTOR.gBaseLang
412: AND NOT EXISTS (SELECT 'Bulkloaded items'
413: FROM icx_cat_items_b i,
414: icx_cat_category_items ci
415: WHERE ci.rt_category_id = cat.rt_category_id
416: AND ci.rt_item_id = i.rt_item_id
417: AND NVL(i.extractor_updated_flag, 'N') = 'N');

Line 427: FROM icx_cat_items_b i,

423: WHERE cat.title = 'Oracle'
424: AND cat.language = ICX_POR_EXTRACTOR.gBaseLang
425: AND key = to_char(pInvCatId)
426: AND NOT EXISTS (SELECT 'Bulkloaded items'
427: FROM icx_cat_items_b i,
428: icx_cat_category_items ci
429: WHERE ci.rt_category_id = cat.rt_category_id
430: AND ci.rt_item_id = i.rt_item_id
431: AND NVL(i.extractor_updated_flag, 'N') = 'N');

Line 594: 'FROM icx_cat_items_b i ' ||

590: IF (pType = 'DELETED_ITEMS') THEN
591: xErrLoc := 240;
592: xString :=
593: 'SELECT i.rt_item_id ' ||
594: 'FROM icx_cat_items_b i ' ||
595: 'WHERE i.extractor_updated_flag = ''Y'' ' ||
596: 'AND i.internal_item_id is not null ';
597:
598: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN

Line 623: 'FROM icx_cat_items_b i, ' ||

619: ELSIF (pType = 'INVALID_CATGORY_ITEMS') THEN
620: xErrLoc := 260;
621: xString :=
622: 'SELECT i.rt_item_id ' ||
623: 'FROM icx_cat_items_b i, ' ||
624: 'icx_cat_item_prices p1 ' ||
625: 'WHERE i.extractor_updated_flag = ''Y'' ' ||
626: 'AND i.internal_item_id is not null ';
627:

Line 669: FROM icx_cat_items_b i

665: ELSIF (pMode = ALL_MODE) THEN
666: xErrLoc := 300;
667: OPEN pCursor FOR
668: SELECT i.rt_item_id
669: FROM icx_cat_items_b i
670: WHERE i.extractor_updated_flag = 'Y';
671:
672: ELSIF (pMode = CATEGORY_MODE) THEN
673: xErrLoc := 400;

Line 676: FROM icx_cat_items_b i,

672: ELSIF (pMode = CATEGORY_MODE) THEN
673: xErrLoc := 400;
674: OPEN pCursor FOR
675: SELECT distinct i.rt_item_id
676: FROM icx_cat_items_b i,
677: icx_cat_item_prices p
678: WHERE p.mtl_category_id = pInvCatItemId
679: AND p.rt_item_id = i.rt_item_id
680: AND i.extractor_updated_flag = 'Y';

Line 686: FROM icx_cat_items_b i

682: ELSIF (pMode = ITEM_MODE) THEN
683: xErrLoc := 500;
684: OPEN pCursor FOR
685: SELECT i.rt_item_id
686: FROM icx_cat_items_b i
687: WHERE i.internal_item_id = pInvCatItemId
688: AND i.extractor_updated_flag = 'Y';
689:
690: END IF;