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

VIEW: APPS.MSC_SUP_DEM_ENTRIES_V

Object Details
Object Name: MSC_SUP_DEM_ENTRIES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMSC.MSC_SUP_DEM_ENTRIES_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 Comments
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)
PUBLISHER_ITEM_NAME VARCHAR2 (250)
TRADING_PARTNER_ITEM_NAME VARCHAR2 (250)
PUB_ITEM_DESCRIPTIION VARCHAR2 (240)
TP_ITEM_DESCRIPTION VARCHAR2 (240)
PUBLISHER_ORDER_TYPE_DESC VARCHAR2 (80)
TP_ORDER_TYPE_DESC VARCHAR2 (80)
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)
PUB_ITEM_DESCRIPTION VARCHAR2 (240)
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

CATEGORY_NAME VARCHAR2 (200)
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)
PLANNED_WIP_START_DATE DATE

PLANNED_WIP_END_DATE DATE

QUANTITY_IN_PROCESS NUMBER

IMPLEMENTED_QUANTITY NUMBER

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)
ACCEPTANCE_REQUIRED_FLAG VARCHAR2 (1)
VMI_FLAG NUMBER

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
,      PUBLISHER_ITEM_NAME
,      TRADING_PARTNER_ITEM_NAME
,      PUB_ITEM_DESCRIPTIION
,      TP_ITEM_DESCRIPTION
,      PUBLISHER_ORDER_TYPE_DESC
,      TP_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
,      PUB_ITEM_DESCRIPTION
,      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
,      CATEGORY_NAME
,      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
,      PLANNED_WIP_START_DATE
,      PLANNED_WIP_END_DATE
,      QUANTITY_IN_PROCESS
,      IMPLEMENTED_QUANTITY
,      ITEM_NAME
,      OWNER_ITEM_NAME
,      CUSTOMER_ITEM_NAME
,      SUPPLIER_ITEM_NAME
,      ITEM_DESCRIPTION
,      CUSTOMER_ITEM_DESCRIPTION
,      SUPPLIER_ITEM_DESCRIPTION
,      OWNER_ITEM_DESCRIPTION
,      ACCEPTANCE_REQUIRED_FLAG
,      VMI_FLAG
FROM APPS.MSC_SUP_DEM_ENTRIES_V;

Dependencies

[top of page]

APPS.MSC_SUP_DEM_ENTRIES_V references the following:

SchemaAPPS
SynonymMSC_SUP_DEM_ENTRIES
APPS.MSC_SUP_DEM_ENTRIES_V is referenced by following:

SchemaAPPS
Package BodyMSC_X_EX5_PKG - show dependent code
Package BodyMSC_X_RECEIVE_CAPACITY_PKG - show dependent code