eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_POR_EXT_ITEM dependencies on ICX_CAT_ITEMS_B

Line 36: supplier icx_cat_items_b.supplier%TYPE,

32: document_type NUMBER,
33: last_update_date DATE,
34: org_id NUMBER,
35: supplier_id NUMBER,
36: supplier icx_cat_items_b.supplier%TYPE,
37: supplier_site_code icx_cat_item_prices.supplier_site_code%TYPE,
38: supplier_part_num icx_cat_items_b.supplier_part_num%TYPE,
39: internal_item_id NUMBER,
40: internal_item_num icx_cat_items_b.internal_item_num%TYPE,

Line 38: supplier_part_num icx_cat_items_b.supplier_part_num%TYPE,

34: org_id NUMBER,
35: supplier_id NUMBER,
36: supplier icx_cat_items_b.supplier%TYPE,
37: supplier_site_code icx_cat_item_prices.supplier_site_code%TYPE,
38: supplier_part_num icx_cat_items_b.supplier_part_num%TYPE,
39: internal_item_id NUMBER,
40: internal_item_num icx_cat_items_b.internal_item_num%TYPE,
41: inventory_organization_id NUMBER,
42: item_source_type icx_cat_items_tlp.item_source_type%TYPE,

Line 40: internal_item_num icx_cat_items_b.internal_item_num%TYPE,

36: supplier icx_cat_items_b.supplier%TYPE,
37: supplier_site_code icx_cat_item_prices.supplier_site_code%TYPE,
38: supplier_part_num icx_cat_items_b.supplier_part_num%TYPE,
39: internal_item_id NUMBER,
40: internal_item_num icx_cat_items_b.internal_item_num%TYPE,
41: inventory_organization_id NUMBER,
42: item_source_type icx_cat_items_tlp.item_source_type%TYPE,
43: item_search_type icx_cat_items_tlp.search_type%TYPE,
44: mtl_category_id NUMBER,

Line 93: price_supplier_part_num icx_cat_items_b.supplier_part_num%TYPE,

89: template_category_id NUMBER,
90: price_rt_item_id NUMBER,
91: price_internal_item_id NUMBER,
92: price_supplier_id NUMBER,
93: price_supplier_part_num icx_cat_items_b.supplier_part_num%TYPE,
94: price_contract_line_id NUMBER,
95: price_mtl_category_id NUMBER,
96: match_primary_category_id NUMBER,
97: rt_item_id NUMBER,

Line 109: internal_item_num ICX_CAT_ITEMS_B.internal_item_num%TYPE,

105:
106: TYPE tItemRecord IS RECORD (
107: org_id NUMBER,
108: internal_item_id NUMBER,
109: internal_item_num ICX_CAT_ITEMS_B.internal_item_num%TYPE,
110: supplier_id NUMBER,
111: supplier ICX_CAT_ITEMS_B.supplier%TYPE,
112: supplier_part_num ICX_CAT_ITEMS_B.supplier_part_num%TYPE,
113: contract_line_id NUMBER,

Line 111: supplier ICX_CAT_ITEMS_B.supplier%TYPE,

107: org_id NUMBER,
108: internal_item_id NUMBER,
109: internal_item_num ICX_CAT_ITEMS_B.internal_item_num%TYPE,
110: supplier_id NUMBER,
111: supplier ICX_CAT_ITEMS_B.supplier%TYPE,
112: supplier_part_num ICX_CAT_ITEMS_B.supplier_part_num%TYPE,
113: contract_line_id NUMBER,
114: rt_item_id NUMBER,
115: hash_value NUMBER);

Line 112: supplier_part_num ICX_CAT_ITEMS_B.supplier_part_num%TYPE,

108: internal_item_id NUMBER,
109: internal_item_num ICX_CAT_ITEMS_B.internal_item_num%TYPE,
110: supplier_id NUMBER,
111: supplier ICX_CAT_ITEMS_B.supplier%TYPE,
112: supplier_part_num ICX_CAT_ITEMS_B.supplier_part_num%TYPE,
113: contract_line_id NUMBER,
114: rt_item_id NUMBER,
115: hash_value NUMBER);
116:

Line 239: -- Insert ICX_CAT_ITEMS_B

235: gIpBuyerIds DBMS_SQL.NUMBER_TABLE;
236: gIPActiveFlags DBMS_SQL.VARCHAR2_TABLE;
237: gIPLastUpdateDates DBMS_SQL.DATE_TABLE;
238:
239: -- Insert ICX_CAT_ITEMS_B
240: gIBRtItemIds DBMS_SQL.NUMBER_TABLE;
241: gIBOrgIds DBMS_SQL.NUMBER_TABLE;
242: gIBSupplierIds DBMS_SQL.NUMBER_TABLE;
243: gIBSuppliers DBMS_SQL.VARCHAR2_TABLE;

Line 248: -- Update ICX_CAT_ITEMS_B

244: gIBSupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
245: gIBInternalItemIds DBMS_SQL.NUMBER_TABLE;
246: gIBInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
247:
248: -- Update ICX_CAT_ITEMS_B
249: gUBRtItemIds DBMS_SQL.NUMBER_TABLE;
250: gUBInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
251: gUBExtractorUpdatedFlags DBMS_SQL.VARCHAR2_TABLE;
252: gUBJobNumbers DBMS_SQL.NUMBER_TABLE;

Line 518: -- Insert ICX_CAT_ITEMS_B

514: gIPLastUpdateDates.DELETE;
515: END IF;
516:
517: IF (pMode IN ('ALL', 'INSERT_ITEMS_B')) THEN
518: -- Insert ICX_CAT_ITEMS_B
519: gIBRtItemIds.DELETE;
520: gIBOrgIds.DELETE;
521: gIBSupplierIds.DELETE;
522: gIBSuppliers.DELETE;

Line 529: -- Update ICX_CAT_ITEMS_B

525: gIBInternalItemNums.DELETE;
526: END IF;
527:
528: IF (pMode IN ('ALL', 'UPDATE_ITEMS_B')) THEN
529: -- Update ICX_CAT_ITEMS_B
530: gUBRtItemIds.DELETE;
531: gUBInternalItemNums.DELETE;
532: gUBExtractorUpdatedFlags.DELETE;
533: gUBJobNumbers.DELETE;

Line 919: -- Insert ICX_CAT_ITEMS_B

915: ICX_POR_EXT_UTL.getTableElement(gIPActiveFlags, pIndex);
916: xShot := xShot || ' gIPLastUpdateDates: ' ||
917: ICX_POR_EXT_UTL.getTableElement(gIPLastUpdateDates, pIndex);
918: ELSIF (pMode = 'INSERT_ITEMS_B') THEN
919: -- Insert ICX_CAT_ITEMS_B
920: xShot := xShot || ' gIBRtItemIds: ' ||
921: ICX_POR_EXT_UTL.getTableElement(gIBRtItemIds, pIndex) || ', ';
922: xShot := xShot || ' gIBOrgIds: ' ||
923: ICX_POR_EXT_UTL.getTableElement(gIBOrgIds, pIndex) || ', ';

Line 935: -- Update ICX_CAT_ITEMS_B

931: ICX_POR_EXT_UTL.getTableElement(gIBInternalItemIds, pIndex) || ', ';
932: xShot := xShot || ' gIBInternalItemNums: ' ||
933: ICX_POR_EXT_UTL.getTableElement(gIBInternalItemNums, pIndex) || ', ';
934: ELSIF (pMode = 'UPDATE_ITEMS_B') THEN
935: -- Update ICX_CAT_ITEMS_B
936: xShot := xShot || ' gUBRtItemIds: ' ||
937: ICX_POR_EXT_UTL.getTableElement(gUBRtItemIds, pIndex) || ', ';
938: xShot := xShot || ' gUBInternalItemNums: ' ||
939: ICX_POR_EXT_UTL.getTableElement(gUBInternalItemNums, pIndex) || ', ';

Line 2255: -- Insert ICX_CAT_ITEMS_B

2251: clearTables(xActionMode);
2252:
2253: xErrLoc := 240;
2254: xActionMode := 'INSERT_ITEMS_B';
2255: -- Insert ICX_CAT_ITEMS_B
2256: IF (ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
2257: FOR i in 1..gIBRtItemIds.COUNT LOOP
2258: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
2259: snapShot(i, xActionMode));

Line 2263: INSERT INTO icx_cat_items_b

2259: snapShot(i, xActionMode));
2260: END LOOP;
2261: END IF;
2262: FORALL i IN 1..gIBRtItemIds.COUNT
2263: INSERT INTO icx_cat_items_b
2264: (rt_item_id, object_version_number, org_id,
2265: supplier_id, supplier, supplier_part_num,
2266: supplier_part_auxid, internal_item_id, internal_item_num,
2267: extractor_updated_flag, catalog_name,

Line 2285: -- Update ICX_CAT_ITEMS_B

2281: clearTables(xActionMode);
2282:
2283: xErrLoc := 260;
2284: xActionMode := 'UPDATE_ITEMS_B';
2285: -- Update ICX_CAT_ITEMS_B
2286: IF (ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
2287: FOR i in 1..gUBRtItemIds.COUNT LOOP
2288: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
2289: snapShot(i, xActionMode));

Line 2293: UPDATE icx_cat_items_b

2289: snapShot(i, xActionMode));
2290: END LOOP;
2291: END IF;
2292: FORALL i IN 1..gUBRtItemIds.COUNT
2293: UPDATE icx_cat_items_b
2294: SET object_version_number = object_version_number + 1,
2295: extractor_updated_flag = gUBExtractorUpdatedFlags(i),
2296: supplier_part_auxid = '##NULL##',
2297: internal_item_num = gUBInternalItemNums(i),

Line 2771: FROM icx_cat_items_b

2767: FORALL i IN 1..gTAInvItemIds.COUNT
2768: INSERT INTO icx_cat_extract_gt
2769: (rt_item_id, type)
2770: SELECT rt_item_id, 'ACTIVE_FLAG'
2771: FROM icx_cat_items_b
2772: WHERE internal_item_id = gTAInvItemIds(i)
2773: AND org_id = NVL(gTAInvOrgIds(i), org_id)
2774: AND supplier IS NULL;
2775: clearTables(xActionMode);

Line 2984: FROM icx_cat_items_b i,

2980: t.primary_category_id,
2981: ICX_POR_EXT_ITEM.getMatchTempalteFlag(gCurrentPrice.price_type,
2982: i.rt_item_id,
2983: gCurrentPrice.template_id) match_template_flag
2984: FROM icx_cat_items_b i,
2985: icx_cat_items_tlp t
2986: WHERE i.internal_item_id = gCurrentPrice.internal_item_id
2987: AND i.org_id = gCurrentPrice.org_id
2988: AND (i.supplier IS NULL AND gCurrentPrice.supplier IS NULL OR

Line 2999: FROM icx_cat_items_b i,

2995: UNION ALL
2996: SELECT p.local_rt_item_id,
2997: TO_NUMBER(NULL_NUMBER) primary_category_id, -- for Global Agreement match
2998: 'N' match_template_flag
2999: FROM icx_cat_items_b i,
3000: icx_cat_item_prices p
3001: WHERE i.internal_item_id = gCurrentPrice.internal_item_id
3002: AND (i.supplier IS NULL AND gCurrentPrice.supplier IS NULL OR
3003: i.supplier = gCurrentPrice.supplier)

Line 3052: FROM icx_cat_items_b i,

3048: t.primary_category_id,
3049: ICX_POR_EXT_ITEM.getMatchTempalteFlag(gCurrentPrice.price_type,
3050: i.rt_item_id,
3051: gCurrentPrice.template_id) match_template_flag
3052: FROM icx_cat_items_b i,
3053: icx_cat_items_tlp t
3054: WHERE i.internal_item_id IS NULL
3055: AND i.org_id = gCurrentPrice.org_id
3056: AND i.supplier = gCurrentPrice.supplier

Line 3065: FROM icx_cat_items_b i,

3061: UNION ALL
3062: SELECT p.local_rt_item_id,
3063: TO_NUMBER(NULL_NUMBER) primary_category_id,
3064: 'N' match_template_flag
3065: FROM icx_cat_items_b i,
3066: icx_cat_item_prices p
3067: WHERE i.internal_item_id IS NULL
3068: AND i.supplier = gCurrentPrice.supplier
3069: AND i.supplier_part_num = gCurrentPrice.supplier_part_num

Line 3098: FROM icx_cat_items_b i

3094: AND p.org_id = gCurrentPrice.org_id
3095: AND p.contract_id = gCurrentPrice.contract_id
3096: AND p.contract_line_id = gCurrentPrice.contract_line_id
3097: AND EXISTS (SELECT 'item with same supplier/supplier_part_num'
3098: FROM icx_cat_items_b i
3099: WHERE i.rt_item_id = p.rt_item_id
3100: AND i.org_id = p.org_id
3101: AND (i.supplier IS NULL AND
3102: gCurrentPrice.supplier IS NULL OR

Line 3121: FROM icx_cat_items_b i

3117: AND p.contract_id = gCurrentPrice.contract_id
3118: AND p.contract_line_id = gCurrentPrice.contract_line_id
3119: AND p.price_type = 'GLOBAL_AGREEMENT'
3120: AND EXISTS (SELECT 'item with same supplier/supplier_part_num'
3121: FROM icx_cat_items_b i
3122: WHERE i.rt_item_id = p.rt_item_id
3123: AND (i.supplier IS NULL AND
3124: gCurrentPrice.supplier IS NULL OR
3125: i.supplier = gCurrentPrice.supplier)

Line 3143: FROM icx_cat_items_b i

3139: OPEN xFoundItemCur FOR
3140: SELECT i.rt_item_id,
3141: TO_NUMBER(NULL) primary_category_id,
3142: TO_CHAR(NULL) match_template_flag
3143: FROM icx_cat_items_b i
3144: WHERE i.internal_item_id = gCurrentPrice.internal_item_id
3145: AND i.org_id = gCurrentPrice.org_id
3146: AND (i.supplier IS NULL AND gCurrentPrice.supplier IS NULL OR
3147: i.supplier = gCurrentPrice.supplier)

Line 3166: FROM icx_cat_items_b i

3162: OPEN xFoundItemCur FOR
3163: SELECT i.rt_item_id,
3164: TO_NUMBER(NULL) primary_category_id,
3165: TO_CHAR(NULL) match_template_flag
3166: FROM icx_cat_items_b i
3167: WHERE i.internal_item_id IS NULL
3168: AND i.org_id = gCurrentPrice.org_id
3169: AND i.supplier = gCurrentPrice.supplier
3170: AND i.supplier_part_num = gCurrentPrice.supplier_part_num

Line 3189: FROM icx_cat_items_b i

3185: AND p.org_id = gCurrentPrice.org_id
3186: AND p.contract_id = gCurrentPrice.contract_id
3187: AND p.contract_line_id = gCurrentPrice.contract_line_id
3188: AND EXISTS (SELECT 'item with same supplier/supplier_part_num'
3189: FROM icx_cat_items_b i
3190: WHERE i.rt_item_id = p.rt_item_id
3191: AND i.org_id = p.org_id
3192: AND (i.supplier IS NULL AND
3193: gCurrentPrice.supplier IS NULL OR

Line 3235: -- ICX_CAT_ITEMS_B | ICX_CAT_ITEM_PRICES

3231: -- For instance: we have a global agreemnt defined in org 101,
3232: -- and enabled in org 102, 103; in org 102, there are two ASLs;
3233: -- in org 103, there is one ASL.
3234: --
3235: -- ICX_CAT_ITEMS_B | ICX_CAT_ITEM_PRICES
3236: -- -------------------------------+------------------------------
3237: -- ID | ITEM | SUP | SPN | ORG | ID | ORG | ACTIVE | LOCAL ID
3238: -- -------------------------------+------------------------------
3239: -- GA: 01 | I1 | s1 | spn1| 101 | 01 | 101 | 'Y' |

Line 4688: -- | |* update ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP |

4684: -- | |_____________________________________________|
4685: -- | | Price Match |
4686: -- | | ---------------- |
4687: -- | |* update ICX_CAT_ITEM_PRICES |
4688: -- | |* update ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP |
4689: -- | |* IF match_primary_category_id <> |
4690: -- | | primary_category_id |
4691: -- | | THEN update ICX_CAT_CATEGORY_ITEMS |
4692: -- | |* don't have to reset active_flag |

Line 4697: -- | |* update ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP |

4693: -- | |_____________________________________________|
4694: -- | | Item Match |
4695: -- | | ---------- |
4696: -- | |* update ICX_CAT_ITEM_PRICES |
4697: -- | |* update ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP |
4698: -- | |* IF match_primary_category_id <> |
4699: -- | | primary_category_id |
4700: -- | | THEN update ICX_CAT_CATEGORY_ITEMS |
4701: -- | |* IF match_template_flag = 'N' |

Line 4711: -- | |* create ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP |

4707: -- | |_____________________________________________|
4708: -- | | New Item |
4709: -- | | -------- |
4710: -- | |* update ICX_CAT_ITEM_PRICES |
4711: -- | |* create ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP |
4712: -- | |* create ICX_CAT_CATEGORY_ITEMS for |
4713: -- | | mtl_category_id |
4714: -- | |* IF template_id IS NOT NULL |
4715: -- | | THEN create ICX_CAT_CATEGORY_ITEMS |

Line 4724: -- | |* update ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP |

4720: -- |_____________|_____________________________________________|
4721: -- | New Price | Item Match |
4722: -- | | ---------- |
4723: -- | |* create ICX_CAT_ITEM_PRICES |
4724: -- | |* update ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP |
4725: -- | |* IF match_primary_category_id <> |
4726: -- | | primary_category_id |
4727: -- | | THEN update ICX_CAT_CATEGORY_ITEMS |
4728: -- | | update ICX_CAT_ITEMS_TLP |

Line 4737: -- | |* create ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP |

4733: -- | |_____________________________________________|
4734: -- | | New Item |
4735: -- | | -------- |
4736: -- | |* create ICX_CAT_ITEM_PRICES |
4737: -- | |* create ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP |
4738: -- | |* create ICX_CAT_CATEGORY_ITEMS for |
4739: -- | | mtl_category_id |
4740: -- | |* IF template_id IS NOT NULL |
4741: -- | | THEN create ICX_CAT_CATEGORY_ITEMS |

Line 6360: 'icx_cat_items_b i ';

6356: xFromStr := xFromStr ||
6357: 'icx_cat_item_prices p, '||
6358: 'icx_cat_categories_tl ic3, '||
6359: 'icx_por_category_data_sources ds3, '||
6360: 'icx_cat_items_b i ';
6361:
6362: xErrLoc := 400;
6363: xWhereStr :=
6364: 'WHERE ic1.key = ds1.category_key '||

Line 6585: 'icx_cat_items_b i ';

6581: 'po_system_parameters_all icx_psp, ';
6582: END IF;
6583: xViewStr2 := xViewStr2 ||
6584: 'icx_cat_item_prices ip, '||
6585: 'icx_cat_items_b i ';
6586:
6587: xErrLoc := 640;
6588: -- Considering global agreement reapproval, use ip.creation_date
6589: xViewStr2 := xViewStr2 ||

Line 6710: 'icx_cat_items_b i '||

6706: 'TO_CHAR(NULL) active_flag, '||
6707: 'ROWIDTOCHAR(p.rowid) price_rowid '||
6708: 'FROM icx_cat_item_prices p, '||
6709: 'icx_cat_extract_ga_gt g, '||
6710: 'icx_cat_items_b i '||
6711: 'WHERE p.contract_id = g.contract_id '||
6712: 'AND p.contract_line_id = g.contract_line_id '||
6713: 'AND p.price_type = ''GLOBAL_AGREEMENT'' '||
6714: 'AND i.rt_item_id = p.rt_item_id ';

Line 6808: 'FROM icx_cat_items_b i ' ||

6804: 'icx_por_loader_values l ' ||
6805: 'WHERE (l.vendor_last_run_date IS NULL OR ' ||
6806: 'v.last_update_date > l.vendor_last_run_date) ' ||
6807: 'AND NOT EXISTS (SELECT ''updated vendor name'' ' ||
6808: 'FROM icx_cat_items_b i ' ||
6809: 'WHERE i.supplier_id = v.vendor_id ' ||
6810: 'AND i.supplier = v.vendor_name)';
6811:
6812: xErrLoc := 140;

Line 6870: UPDATE icx_cat_items_b

6866: xNewVendorNames.DELETE;
6867:
6868: xErrLoc := 240;
6869: FORALL i in 1..xVendorId.COUNT
6870: UPDATE icx_cat_items_b
6871: SET supplier = xVendorName(i),
6872: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
6873: last_update_date = SYSDATE,
6874: last_update_login = ICX_POR_EXTRACTOR.gLoginId,

Line 7483: FROM icx_cat_items_b

7479: FORALL i IN 1..gDPInventoryItemIds.COUNT
7480: INSERT INTO icx_cat_extract_gt
7481: (rt_item_id, type)
7482: SELECT rt_item_id, 'ACTIVE_FLAG'
7483: FROM icx_cat_items_b
7484: WHERE internal_item_id = gDPInventoryItemIds(i)
7485: AND org_id = NVL(gDPOrgIds(i), org_id)
7486: AND supplier IS NULL;
7487: