[Home] [Help] [Dependency Information]

VIEW: APPS.WSH_DSNO_ORDERS_V

Object Details

Object Name:	WSH_DSNO_ORDERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WSH.WSH_DSNO_ORDERS_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 DELIVERY_ID
,      CONTAINER_INSTANCE_ID
,      ORDER_HEADER_ID
,      PURCHASE_ORDER_NUMBER
,      PURCHASE_ORDER_DATE
,      SALES_ORDER_NUMBER
,      SALES_ORDER_DATE
,      AGREEMENT_NUMBER_INT
,      ORDER_TYPE_INT
,      ORDER_CATEGORY_CODE
,      CUSTOMER_REQUEST_DATE
,      ORDER_DATE_TYPE_CODE
,      PARTIAL_SHIPMENTS_ALLOWED
,      FOB_PAYMENT_METHOD_CODE_INT
,      ORDER_BY_ADDRESS_ID
,      ORDER_BY_CODE_INT
,      ORDER_BY_EDI_LOC_CODE
,      ORDER_BY_TP_REF_1
,      ORDER_BY_TP_REF_2
,      ORDER_BY_NAME
,      ORDER_BY_ADDRESS1
,      ORDER_BY_ADDRESS2
,      ORDER_BY_ADDRESS3
,      ORDER_BY_ADDRESS4
,      ORDER_BY_CITY
,      ORDER_BY_POSTAL_CODE
,      ORDER_BY_COUNTRY_INT
,      ORDER_BY_STATE_INT
,      ORDER_BY_PROVINCE_INT
,      ORDER_BY_COUNTY
,      ORDER_BY_CONTACT_LAST_NAME
,      ORDER_BY_CONTACT_FIRST_NAME
,      ORDER_BY_CONTACT_JOB_TITLE
,      ORDER_BY_AREA_CODE
,      ORDER_BY_TELEPHONE
,      INVOICE_ADDRESS_ID
,      INVOICE_CODE_INT
,      INVOICE_EDI_LOC_CODE
,      INVOICE_TP_REF_1
,      INVOICE_TP_REF_2
,      INVOICE_NAME
,      INVOICE_ADDRESS1
,      INVOICE_ADDRESS2
,      INVOICE_ADDRESS3
,      INVOICE_ADDRESS4
,      INVOICE_CITY
,      INVOICE_POSTAL_CODE
,      INVOICE_COUNTRY_INT
,      INVOICE_STATE_INT
,      INVOICE_PROVINCE_INT
,      INVOICE_COUNTY
,      INVOICE_CONTACT_LAST_NAME
,      INVOICE_CONTACT_FIRST_NAME
,      INVOICE_CONTACT_JOB_TITLE
,      INVOICE_AREA_CODE
,      INVOICE_TELEPHONE
,      TAX_EXEMPT_FLAG
,      TAX_EXEMPT_NUMBER
,      TAX_EXEMPT_REASON_CODE_INT
,      TRANSACTIONAL_CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      PAYMENT_TERMS_INT
,      PAYMENT_AMOUNT
,      FOB_POINT_CODE_INT
,      FREIGHT_TERMS_CODE_INT
,      ORDER_HEADER_CONTEXT
,      ORDER_HEADER_ATTRIBUTE1
,      ORDER_HEADER_ATTRIBUTE2
,      ORDER_HEADER_ATTRIBUTE3
,      ORDER_HEADER_ATTRIBUTE4
,      ORDER_HEADER_ATTRIBUTE5
,      ORDER_HEADER_ATTRIBUTE6
,      ORDER_HEADER_ATTRIBUTE7
,      ORDER_HEADER_ATTRIBUTE8
,      ORDER_HEADER_ATTRIBUTE9
,      ORDER_HEADER_ATTRIBUTE10
,      ORDER_HEADER_ATTRIBUTE11
,      ORDER_HEADER_ATTRIBUTE12
,      ORDER_HEADER_ATTRIBUTE13
,      ORDER_HEADER_ATTRIBUTE14
,      ORDER_HEADER_ATTRIBUTE15
,      OH_GLOBAL_CATEGORY
,      OH_GLOBAL_ATTRIBUTE1
,      OH_GLOBAL_ATTRIBUTE2
,      OH_GLOBAL_ATTRIBUTE3
,      OH_GLOBAL_ATTRIBUTE4
,      OH_GLOBAL_ATTRIBUTE5
,      OH_GLOBAL_ATTRIBUTE6
,      OH_GLOBAL_ATTRIBUTE7
,      OH_GLOBAL_ATTRIBUTE8
,      OH_GLOBAL_ATTRIBUTE9
,      OH_GLOBAL_ATTRIBUTE10
,      OH_GLOBAL_ATTRIBUTE11
,      OH_GLOBAL_ATTRIBUTE12
,      OH_GLOBAL_ATTRIBUTE13
,      OH_GLOBAL_ATTRIBUTE14
,      OH_GLOBAL_ATTRIBUTE15
,      OH_GLOBAL_ATTRIBUTE16
,      OH_GLOBAL_ATTRIBUTE17
,      OH_GLOBAL_ATTRIBUTE18
,      OH_GLOBAL_ATTRIBUTE19
,      OH_GLOBAL_ATTRIBUTE20
,      ORDER_HEADER_TP_CONTEXT
,      ORDER_HEADER_TP_ATTRIBUTE1
,      ORDER_HEADER_TP_ATTRIBUTE2
,      ORDER_HEADER_TP_ATTRIBUTE3
,      ORDER_HEADER_TP_ATTRIBUTE4
,      ORDER_HEADER_TP_ATTRIBUTE5
,      ORDER_HEADER_TP_ATTRIBUTE6
,      ORDER_HEADER_TP_ATTRIBUTE7
,      ORDER_HEADER_TP_ATTRIBUTE8
,      ORDER_HEADER_TP_ATTRIBUTE9
,      ORDER_HEADER_TP_ATTRIBUTE10
,      ORDER_HEADER_TP_ATTRIBUTE11
,      ORDER_HEADER_TP_ATTRIBUTE12
,      ORDER_HEADER_TP_ATTRIBUTE13
,      ORDER_HEADER_TP_ATTRIBUTE14
,      ORDER_HEADER_TP_ATTRIBUTE15
FROM APPS.WSH_DSNO_ORDERS_V;

Dependencies

[top of page]

APPS

WSH_DSNO_OKE - show dependent code

WSH_DSNO_ORDERS_COMM_V

WSH_DSNO_ORDERS_SPECIFIC_V

WSH_ECE_VIEWS_DEF - show dependent code

APPS.WSH_DSNO_ORDERS_V is not referenced by any database object