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.WSH_OPSM_ASN_ORDERS_SPECIFIC_V

Object Details

Object Name:	WSH_OPSM_ASN_ORDERS_SPECIFIC_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WSH.WSH_OPSM_ASN_ORDERS_SPECIFIC_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
SOURCE_CODE	CHAR	(2)
SOURCE_HEADER_ID	NUMBER		Yes
SALES_ORDER_DATE	DATE
SALES_ORDER_NUMBER	NUMBER		Yes
ORDER_TYPE_INT	VARCHAR2	(30)
ORDER_CATEGORY_CODE	VARCHAR2	(30)	Yes
INVOICE_TO_ORG_ID	NUMBER
INVOICE_TO_CONTACT_ID	NUMBER
SHIP_TO_CONTACT_ID	NUMBER
INVOICE_NAME	VARCHAR2	(50)
INVOICE_ADDRESS_ID	NUMBER	(15)
INVOICE_CODE_INT	VARCHAR2	(40)
INVOICE_ADDRESS1	VARCHAR2	(240)
INVOICE_ADDRESS2	VARCHAR2	(240)
INVOICE_ADDRESS3	VARCHAR2	(240)
INVOICE_ADDRESS4	VARCHAR2	(240)
INVOICE_CITY	VARCHAR2	(60)
INVOICE_POSTAL_CODE	VARCHAR2	(60)
INVOICE_COUNTRY_INT	VARCHAR2	(60)
INVOICE_STATE_INT	VARCHAR2	(60)
INVOICE_PROVINCE_INT	VARCHAR2	(60)
INVOICE_COUNTY	VARCHAR2	(60)
INVOICE_CONT_NAME	VARCHAR2	(301)
INVOICE_CONT_JOB_TITLE	VARCHAR2	(100)
INVOICE_CONT_EMAIL_ADDRESS	VARCHAR2	(2000)
INVOICE_CONT_COUNTRY_CODE	VARCHAR2	(10)
INVOICE_CONT_AREA_CODE	VARCHAR2	(10)
INVOICE_CONT_PHONE_NUMBER	VARCHAR2	(40)
INVOICE_CONT_PHONE_EXTN	VARCHAR2	(20)

Query Text

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


SELECT SOURCE_CODE
,      SOURCE_HEADER_ID
,      SALES_ORDER_DATE
,      SALES_ORDER_NUMBER
,      ORDER_TYPE_INT
,      ORDER_CATEGORY_CODE
,      INVOICE_TO_ORG_ID
,      INVOICE_TO_CONTACT_ID
,      SHIP_TO_CONTACT_ID
,      INVOICE_NAME
,      INVOICE_ADDRESS_ID
,      INVOICE_CODE_INT
,      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_CONT_NAME
,      INVOICE_CONT_JOB_TITLE
,      INVOICE_CONT_EMAIL_ADDRESS
,      INVOICE_CONT_COUNTRY_CODE
,      INVOICE_CONT_AREA_CODE
,      INVOICE_CONT_PHONE_NUMBER
,      INVOICE_CONT_PHONE_EXTN
FROM APPS.WSH_OPSM_ASN_ORDERS_SPECIFIC_V;

Dependencies

[top of page]

APPS.WSH_OPSM_ASN_ORDERS_SPECIFIC_V references the following:

APPS: FND_LANGUAGES; HZ_CONTACT_POINTS; HZ_CUST_ACCOUNTS; 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_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL; OE_TRANSACTION_TYPES_TL

APPS.WSH_OPSM_ASN_ORDERS_SPECIFIC_V is referenced by following:

APPS: WSH_OPSM_ASN_DELIVERIES_V