Labels

[ALRT] (3) [AR] (2) [BOM] (3) [GL] (2) [GTM] (1) [INV] (18) [MRP] (1) [OM] (27) [PO] (58) [QP] (3) [SYS] (39) [WIP] (4) AGIS (1) OM (1)

Wednesday, December 22, 2010

[INV] Item Cross References in Item Search

We have setup different Cross Reference Types for OM usage. Each type was defined in different inventory organization.

Now, in Production instance I do not have access to view the assignment (Items->Cross References was excluded). How can I check it?

Front End:
Use Item Search (Items->Item Search). Enter the inventory org, make sure the Show value is Cross References. Enter the Cross Reference Type andValue, click Find. We can see the assignment in the next screen.

Back End:
select cross_reference_type type, cross_reference selling_sku,
inv_item_concat_segs stocking_sku, description
from apps.MTL_CROSS_REFERENCES_V where cross_reference_type='ABC_XREF' and
cross_reference in
('ABCD');

No comments:

Post a Comment