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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.MSC_SUP_DEM_ENTRIES_UI_V

Object Details

Object Name:	MSC_SUP_DEM_ENTRIES_UI_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MSC.MSC_SUP_DEM_ENTRIES_UI_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory
TRANSACTION_ID	NUMBER		Yes
PLAN_ID	NUMBER		Yes
SR_INSTANCE_ID	NUMBER
PUBLISHER_ID	NUMBER		Yes
PUBLISHER_SITE_ID	NUMBER		Yes
PUBLISHER_NAME	VARCHAR2	(255)
PUBLISHER_SITE_NAME	VARCHAR2	(40)
NEW_SCHEDULE_DATE	DATE
INVENTORY_ITEM_ID	NUMBER		Yes
QUANTITY	NUMBER		Yes
TP_QUANTITY	NUMBER
COMMENTS	VARCHAR2	(1000)
PUBLISHER_ORDER_TYPE	NUMBER		Yes
SUPPLIER_ID	NUMBER
SUPPLIER_NAME	VARCHAR2	(255)
SUPPLIER_SITE_ID	NUMBER
SUPPLIER_SITE_NAME	VARCHAR2	(40)
CUSTOMER_ID	NUMBER
CUSTOMER_NAME	VARCHAR2	(255)
CUSTOMER_SITE_ID	NUMBER
CUSTOMER_SITE_NAME	VARCHAR2	(40)
LINE_CODE	VARCHAR2	(30)
BUCKET_TYPE	NUMBER
ORDER_NUMBER	VARCHAR2	(240)
END_ORDER_NUMBER	VARCHAR2	(240)
NEW_DOCK_DATE	DATE
POSTING_PARTY_ID	NUMBER
NEW_SHIP_DATE	DATE
NEW_ORDER_PLACEMENT_DATE	DATE
RELEASE_NUMBER	VARCHAR2	(25)
LINE_NUMBER	VARCHAR2	(25)
END_ORDER_REL_NUMBER	VARCHAR2	(25)
END_ORDER_LINE_NUMBER	VARCHAR2	(25)
PUBLISHER_ADDRESS_ID	NUMBER
CARRIER_CODE	VARCHAR2	(30)
VEHICLE_NUMBER	VARCHAR2	(30)
CONTAINER_TYPE	VARCHAR2	(20)
CONTAINER_QTY	NUMBER
TRACKING_NUMBER	VARCHAR2	(240)
VERSION	VARCHAR2	(240)
END_ORDER_TYPE	NUMBER
END_ORDER_PUBLISHER_ID	NUMBER
SHIP_TO_ADDRESS	VARCHAR2	(240)
SHIP_FROM_PARTY_ID	NUMBER
SHIP_TO_PARTY_ID	NUMBER
SHIP_TO_PARTY_SITE_ID	NUMBER
SHIP_TO_PARTY_ADDRESS_ID	NUMBER
SHIP_TO_PARTY_NAME	VARCHAR2	(255)
SHIP_TO_PARTY_SITE_NAME	VARCHAR2	(40)
SHIP_FROM_PARTY_ADDRESS_ID	NUMBER
SHIP_FROM_PARTY_SITE_ID	NUMBER
SHIP_FROM_PARTY_NAME	VARCHAR2	(255)
SHIP_FROM_PARTY_SITE_NAME	VARCHAR2	(40)
OWNING_SITE_ID	NUMBER
OWNING_SITE_NAME	VARCHAR2	(40)
END_ORDER_PUBLISHER_SITE_ID	NUMBER
END_ORDER_PUBLISHER_SITE_NAME	VARCHAR2	(40)
END_ORDER_PUBLISHER_NAME	VARCHAR2	(255)
ITEM_NAME	VARCHAR2	(250)
OWNER_ITEM_NAME	VARCHAR2	(250)
CUSTOMER_ITEM_NAME	VARCHAR2	(250)
SUPPLIER_ITEM_NAME	VARCHAR2	(250)
ITEM_DESCRIPTION	VARCHAR2	(240)
CUSTOMER_ITEM_DESCRIPTION	VARCHAR2	(240)
SUPPLIER_ITEM_DESCRIPTION	VARCHAR2	(240)
OWNER_ITEM_DESCRIPTION	VARCHAR2	(240)
PUBLISHER_ORDER_TYPE_DESC	VARCHAR2	(80)	Yes
DESIGNATOR	VARCHAR2	(100)
CONTEXT	VARCHAR2	(30)
UNIT_NUMBER	VARCHAR2	(30)
SHIP_METHOD	VARCHAR2	(30)
PROJECT_NUMBER	VARCHAR2	(30)
TASK_NUMBER	VARCHAR2	(30)
PLANNING_GROUP	VARCHAR2	(30)
SHIP_FROM_ADDRESS	VARCHAR2	(240)
PUBLISHER_ADDRESS	VARCHAR2	(240)
CUSTOMER_ADDRESS	VARCHAR2	(240)
SUPPLIER_ADDRESS	VARCHAR2	(240)
AVERAGE_ANNUAL_DEMAND	NUMBER
BILL_OF_LADING_NUMBER	VARCHAR2	(30)
BUCKET_TYPE_DESC	VARCHAR2	(30)
SERIAL_NUMBER	VARCHAR2	(255)
RELEASE_STATUS	NUMBER
INVENTORY_STATUS	VARCHAR2	(20)
WIP_END_DATE	DATE
WIP_START_DATE	DATE
PROMISE_SHIP_DATE	DATE
NEW_SCHEDULE_END_DATE	DATE
POSTING_PARTY_NAME	VARCHAR2	(255)
UOM_CODE	VARCHAR2	(3)
TP_UOM_CODE	VARCHAR2	(3)
PLANNER_CODE	VARCHAR2	(10)
LAST_REFRESH_NUMBER	NUMBER
ATTACHMENT_URL	VARCHAR2	(240)
ATTRIBUTE1	VARCHAR2	(240)
ATTRIBUTE2	VARCHAR2	(240)
ATTRIBUTE3	VARCHAR2	(240)
ATTRIBUTE4	VARCHAR2	(240)
ATTRIBUTE5	VARCHAR2	(240)
ATTRIBUTE6	VARCHAR2	(240)
ATTRIBUTE7	VARCHAR2	(240)
ATTRIBUTE8	VARCHAR2	(240)
ATTRIBUTE9	VARCHAR2	(240)
ATTRIBUTE10	VARCHAR2	(240)
ATTRIBUTE11	VARCHAR2	(240)
ATTRIBUTE12	VARCHAR2	(240)
ATTRIBUTE13	VARCHAR2	(240)
ATTRIBUTE14	VARCHAR2	(240)
ATTRIBUTE15	VARCHAR2	(240)
REQUEST_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
CREATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER
KEY_DATE	DATE
SHIP_DATE	DATE
RECEIPT_DATE	DATE
ORIGINAL_PROMISED_DATE	DATE
REQUEST_DATE	DATE
PRIMARY_UOM	VARCHAR2	(3)
PRIMARY_QUANTITY	NUMBER
REF_HEADER_ID	NUMBER
REF_LINE_ID	NUMBER
PUBLISHER_ORG_ID	NUMBER
SUBSCRIBER_ORG_ID	NUMBER
ASSEMBLY_ITEM_ID	NUMBER
CATEGORY_ID	NUMBER
START_DATE	DATE
END_DATE	NUMBER
PRODUCTION_SEQUENCE	VARCHAR2	(30)
SEQ_PLAN_COMPLETION_FLAG	VARCHAR2	(1)
INPUT_PLAN_ID	NUMBER
END_ASSEMBLY_ITEM_NAME	VARCHAR2	(250)
SUBSCRIBER_ADDRESS_ID	NUMBER
TP_ORDER_TYPE	NUMBER
PROCESSED_FLAG	VARCHAR2	(1)
PRIVILEGE	VARCHAR2	(0)
VIEWER_COMPANY	VARCHAR2	(255)
VIEWER_SITE	VARCHAR2	(40)
TP_COMPANY	VARCHAR2	(255)
TP_SITE	VARCHAR2	(40)
THIRD_PARTY_FLAG	NUMBER
BASE_ITEM_ID	NUMBER
BASE_ITEM_NAME	VARCHAR2	(250)
SHIPPING_CONTROL	VARCHAR2	(30)
BUYER_NAME	VARCHAR2	(4000)
CATEGORY_NAME	VARCHAR2	(4000)
END_ORDER_TYPE_DESC	VARCHAR2	(80)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TRANSACTION_ID
,      PLAN_ID
,      SR_INSTANCE_ID
,      PUBLISHER_ID
,      PUBLISHER_SITE_ID
,      PUBLISHER_NAME
,      PUBLISHER_SITE_NAME
,      NEW_SCHEDULE_DATE
,      INVENTORY_ITEM_ID
,      QUANTITY
,      TP_QUANTITY
,      COMMENTS
,      PUBLISHER_ORDER_TYPE
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE_NAME
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_SITE_ID
,      CUSTOMER_SITE_NAME
,      LINE_CODE
,      BUCKET_TYPE
,      ORDER_NUMBER
,      END_ORDER_NUMBER
,      NEW_DOCK_DATE
,      POSTING_PARTY_ID
,      NEW_SHIP_DATE
,      NEW_ORDER_PLACEMENT_DATE
,      RELEASE_NUMBER
,      LINE_NUMBER
,      END_ORDER_REL_NUMBER
,      END_ORDER_LINE_NUMBER
,      PUBLISHER_ADDRESS_ID
,      CARRIER_CODE
,      VEHICLE_NUMBER
,      CONTAINER_TYPE
,      CONTAINER_QTY
,      TRACKING_NUMBER
,      VERSION
,      END_ORDER_TYPE
,      END_ORDER_PUBLISHER_ID
,      SHIP_TO_ADDRESS
,      SHIP_FROM_PARTY_ID
,      SHIP_TO_PARTY_ID
,      SHIP_TO_PARTY_SITE_ID
,      SHIP_TO_PARTY_ADDRESS_ID
,      SHIP_TO_PARTY_NAME
,      SHIP_TO_PARTY_SITE_NAME
,      SHIP_FROM_PARTY_ADDRESS_ID
,      SHIP_FROM_PARTY_SITE_ID
,      SHIP_FROM_PARTY_NAME
,      SHIP_FROM_PARTY_SITE_NAME
,      OWNING_SITE_ID
,      OWNING_SITE_NAME
,      END_ORDER_PUBLISHER_SITE_ID
,      END_ORDER_PUBLISHER_SITE_NAME
,      END_ORDER_PUBLISHER_NAME
,      ITEM_NAME
,      OWNER_ITEM_NAME
,      CUSTOMER_ITEM_NAME
,      SUPPLIER_ITEM_NAME
,      ITEM_DESCRIPTION
,      CUSTOMER_ITEM_DESCRIPTION
,      SUPPLIER_ITEM_DESCRIPTION
,      OWNER_ITEM_DESCRIPTION
,      PUBLISHER_ORDER_TYPE_DESC
,      DESIGNATOR
,      CONTEXT
,      UNIT_NUMBER
,      SHIP_METHOD
,      PROJECT_NUMBER
,      TASK_NUMBER
,      PLANNING_GROUP
,      SHIP_FROM_ADDRESS
,      PUBLISHER_ADDRESS
,      CUSTOMER_ADDRESS
,      SUPPLIER_ADDRESS
,      AVERAGE_ANNUAL_DEMAND
,      BILL_OF_LADING_NUMBER
,      BUCKET_TYPE_DESC
,      SERIAL_NUMBER
,      RELEASE_STATUS
,      INVENTORY_STATUS
,      WIP_END_DATE
,      WIP_START_DATE
,      PROMISE_SHIP_DATE
,      NEW_SCHEDULE_END_DATE
,      POSTING_PARTY_NAME
,      UOM_CODE
,      TP_UOM_CODE
,      PLANNER_CODE
,      LAST_REFRESH_NUMBER
,      ATTACHMENT_URL
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      KEY_DATE
,      SHIP_DATE
,      RECEIPT_DATE
,      ORIGINAL_PROMISED_DATE
,      REQUEST_DATE
,      PRIMARY_UOM
,      PRIMARY_QUANTITY
,      REF_HEADER_ID
,      REF_LINE_ID
,      PUBLISHER_ORG_ID
,      SUBSCRIBER_ORG_ID
,      ASSEMBLY_ITEM_ID
,      CATEGORY_ID
,      START_DATE
,      END_DATE
,      PRODUCTION_SEQUENCE
,      SEQ_PLAN_COMPLETION_FLAG
,      INPUT_PLAN_ID
,      END_ASSEMBLY_ITEM_NAME
,      SUBSCRIBER_ADDRESS_ID
,      TP_ORDER_TYPE
,      PROCESSED_FLAG
,      PRIVILEGE
,      VIEWER_COMPANY
,      VIEWER_SITE
,      TP_COMPANY
,      TP_SITE
,      THIRD_PARTY_FLAG
,      BASE_ITEM_ID
,      BASE_ITEM_NAME
,      SHIPPING_CONTROL
,      BUYER_NAME
,      CATEGORY_NAME
,      END_ORDER_TYPE_DESC
FROM APPS.MSC_SUP_DEM_ENTRIES_UI_V;