[Home] [Help] [Dependency Information]

VIEW: APPS.WSH_DSNO_ORDERS_SPECIFIC_V

Object Details

Object Name:	WSH_DSNO_ORDERS_SPECIFIC_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WSH.WSH_DSNO_ORDERS_SPECIFIC_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 SOURCE_CODE
,      SOURCE_HEADER_ID
,      PURCHASE_ORDER_DATE
,      SALES_ORDER_DATE
,      SALES_ORDER_NUMBER
,      AGREEMENT_NUMBER_INT
,      ORDER_TYPE_INT
,      ORDER_CATEGORY_CODE
,      CUSTOMER_REQUEST_DATE
,      ORDER_DATE_TYPE_CODE
,      PARTIAL_SHIPMENTS_ALLOWED
,      FOB_PAYMENT_METHOD_CODE_INT
,      INVOICE_ADDRESS_ID
,      INVOICE_CODE_INT
,      INVOICE_EDI_LOC_CODE
,      INVOICE_TP_REF_1
,      INVOICE_TP_REF_2
,      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
,      CURRENCY_CONVERSION_TYPE_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      DELIVERY_ID
,      PAYMENT_TERMS_INT
,      PAYMENT_AMOUNT
,      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
,      PURCHASE_ORDER_NUMBER
,      FOB_POINT_CODE_INT
,      FREIGHT_TERMS_CODE_INT
,      TRANSACTIONAL_CURRENCY_CODE
FROM APPS.WSH_DSNO_ORDERS_SPECIFIC_V;

Dependencies

[top of page]

APPS

ECE_TP_HEADERS

HZ_CUST_ACCOUNT_ROLES

HZ_CUST_ACCT_SITES_ALL

HZ_CUST_SITE_USES_ALL

HZ_LOCATIONS

HZ_ORG_CONTACTS

HZ_PARTIES

HZ_PARTY_SITES

HZ_RELATIONSHIPS

OE_AGREEMENTS_B

OE_ORDER_HEADERS_ALL

OE_TRANSACTION_TYPES_TL

OKC_K_HEADERS_B

OKE_K_FUNDING_SOURCES

OKE_K_HEADERS

OKE_K_TERMS

RA_TERMS

WSH_DELIVERY_ASSIGNMENTS_V

WSH_DELIVERY_DETAILS

WSH_DSNO_OKE - show dependent code

WSH_ECE_VIEWS_DEF - show dependent code

APPS

WSH_DSNO_ORDERS_V