[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:	MSC.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

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

APPS

MSC_X_EX5_PKG - show dependent code

MSC_X_RECEIVE_CAPACITY_PKG - show dependent code