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_X_SUPPLY_DEMAND_V

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

View Text

SELECT DMD.PLAN_ID
, XREF.PARTY_ID
, XREF.PARTY_NAME
, XREF.ITEM_ID
, XREF.ITEM_NUMBER
, XREF.SHORT_DESCRIPTION
, XREF.LONG_DESCRIPTION
, XREF.REF_PARTY_ID
, XREF.REF_PARTY_NAME
, XREF.REF_ITEM_ID
, XREF.REF_ITEM_NUMBER
, XREF.REF_SHORT_DESCRIPTION
, XREF.REF_LONG_DESCRIPTION
, DMD.ORIGINATION_TYPE
, DMD.USING_ASSEMBLY_DEMAND_DATE
, DMD.USING_REQUIREMENT_QUANTITY
FROM MSC_ITEM_CROSS_REFS_V XREF
, MSC_DEMANDS DMD
WHERE DMD.SR_INSTANCE_ID = -1
AND XREF.REF_ITEM_ID = DMD.INVENTORY_ITEM_ID
AND XREF.PARTY_ID = DMD.CUSTOMER_SITE_ID
AND XREF.REF_PARTY_ID = DMD.ORGANIZATION_ID UNION SELECT SUP.PLAN_ID
, XREF.PARTY_ID
, XREF.PARTY_NAME
, XREF.ITEM_ID
, XREF.ITEM_NUMBER
, XREF.SHORT_DESCRIPTION
, XREF.LONG_DESCRIPTION
, XREF.REF_PARTY_ID
, XREF.REF_PARTY_NAME
, XREF.REF_ITEM_ID
, XREF.REF_ITEM_NUMBER
, XREF.REF_SHORT_DESCRIPTION
, XREF.REF_LONG_DESCRIPTION
, SUP.ORDER_TYPE
, SUP.NEW_SCHEDULE_DATE
, SUP.NEW_ORDER_QUANTITY
FROM MSC_ITEM_CROSS_REFS_V XREF
, MSC_SUPPLIES SUP
WHERE SUP.SR_INSTANCE_ID = -1
AND XREF.ITEM_ID = SUP.INVENTORY_ITEM_ID
AND XREF.PARTY_ID = SUP.ORGANIZATION_ID
AND XREF.REF_PARTY_ID = SUP.SUPPLIER_SITE_ID

Columns

Name
PLAN_ID
BUYER_PARTY_ID
BUYER_PARTY_NAME
BUYER_ITEM_ID
BUYER_ITEM_NUMBER
BUYER_ITEM_SHORT_DESCRIPTION
BUYER_ITEM_LONG_DESCRIPTION
SELLER_PARTY_ID
SELLER_PARTY_NAME
SELLER_ITEM_ID
SELLER_ITEM_NUMBER
SELLER_ITEM_SHORT_DESCRIPTION
SELLER_ITEM_LONG_DESCRIPTION
TRANSACTION_TYPE
TRANSACTION_DATE
QUANTITY