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.

[Home] [Help]

View: MSC_ITEM_CROSS_REFS_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT CR.ITEM_ID
, IT1.PARTY_ITEM_NUMBER
, IT1.SHORT_DESCRIPTION
, IT1.LONG_DESCRIPTION
, IT1.PARTY_ID
, IT1.PARTY_NAME
, CR.REF_ITEM_ID
, IT2.PARTY_ITEM_NUMBER
, IT2.SHORT_DESCRIPTION
, IT2.LONG_DESCRIPTION
, IT2.PARTY_ID
, IT2.PARTY_NAME
FROM IPD_ITEM_CROSS_REFS_B CR
, IPD_ITEMS_V IT1
, IPD_ITEMS_V IT2
WHERE IT1.ITEM_ID = CR.ITEM_ID
AND IT2.ITEM_ID = CR.REF_ITEM_ID
AND CR.REF_TYPE='IDENTICAL' UNION SELECT CR.REF_ITEM_ID
, IT1.PARTY_ITEM_NUMBER
, IT1.SHORT_DESCRIPTION
, IT1.LONG_DESCRIPTION
, IT1.PARTY_ID
, IT1.PARTY_NAME
, CR.ITEM_ID
, IT2.PARTY_ITEM_NUMBER
, IT2.SHORT_DESCRIPTION
, IT2.LONG_DESCRIPTION
, IT2.PARTY_ID
, IT2.PARTY_NAME
FROM IPD_ITEM_CROSS_REFS_B CR
, IPD_ITEMS_V IT1
, IPD_ITEMS_V IT2
WHERE IT1.ITEM_ID = CR.REF_ITEM_ID
AND IT2.ITEM_ID = CR.ITEM_ID
AND CR.REF_TYPE='IDENTICAL'

Columns

Name
ITEM_ID
ITEM_NUMBER
SHORT_DESCRIPTION
LONG_DESCRIPTION
PARTY_ID
PARTY_NAME
REF_ITEM_ID
REF_ITEM_NUMBER
REF_SHORT_DESCRIPTION
REF_LONG_DESCRIPTION
REF_PARTY_ID
REF_PARTY_NAME