[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 |