Tuesday, 13 January 2015

Query to find item cross-references :

SELECT   msi.segment1 item,
           mcr.cross_reference_type reference_type,
           mcr.cross_reference,
           mcr.description
    FROM   mtl_cross_references mcr, mtl_system_items msi
   WHERE       mcr.cross_reference_type = 'Vendor'
           AND mcr.inventory_item_id = msi.inventory_item_id
           AND mcr.organization_id = msi.organization_id
ORDER BY   1, 2
/

2 comments:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, BI Publisher, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete
  2. can you give me a total query about cross reference types and assign form in inventory

    ReplyDelete