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_COMM_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
DELIVERY_ID	NUMBER
SOURCE_CODE	VARCHAR2	(30)	Yes
ORDER_HEADER_ID	NUMBER
SOLDTO_CUSTOMER_ID	NUMBER
SOLDTO_CONTACT_ID	NUMBER
SOLDTO_ADDRESS_ID	NUMBER	(15)
SOLDTO_CODE_INT	VARCHAR2	(40)
SOLDTO_NAME	VARCHAR2	(50)
SOLDTO_ADDRESS1	VARCHAR2	(240)
SOLDTO_ADDRESS2	VARCHAR2	(240)
SOLDTO_ADDRESS3	VARCHAR2	(240)
SOLDTO_ADDRESS4	VARCHAR2	(240)
SOLDTO_CITY	VARCHAR2	(60)
SOLDTO_POSTAL_CODE	VARCHAR2	(60)
SOLDTO_COUNTRY_INT	VARCHAR2	(60)
SOLDTO_STATE_INT	VARCHAR2	(60)
SOLDTO_PROVINCE_INT	VARCHAR2	(60)
SOLDTO_COUNTY	VARCHAR2	(60)
SOLDTO_CONT_NAME	VARCHAR2	(301)
SOLDTO_CONT_JOB_TITLE	VARCHAR2	(100)
SOLDTO_CONT_EMAIL	VARCHAR2	(2000)
SOLDTO_CONT_COUNTRY_CODE	VARCHAR2	(10)
SOLDTO_CONT_AREA_CODE	VARCHAR2	(10)
SOLDTO_CONT_PHONE_NUMBER	VARCHAR2	(40)
SOLDTO_CONT_PHONE_EXTN	VARCHAR2	(20)
SOLDBY_LOCATION_CODE	VARCHAR2	(60)
SOLDBY_COUNTRY	VARCHAR2	(120)
SOLDBY_ADDRESS_LINE_1	VARCHAR2	(240)
SOLDBY_ADDRESS_LINE_2	VARCHAR2	(240)
SOLDBY_ADDRESS_LINE_3	VARCHAR2	(240)
SOLDBY_ADDRESS_LINE_4	VARCHAR2	(240)
SOLDBY_COUNTY	VARCHAR2	(120)
SOLDBY_STATE	VARCHAR2	(120)
SOLDBY_POSTAL_CODE	VARCHAR2	(60)
SOLDBY_CITY	VARCHAR2	(120)
SOLDBY_ORGANIZATION_ID	NUMBER	(15)	Yes
SOLDBY_NAME	VARCHAR2	(240)	Yes
SOLDBY_CONTACT_NAME	VARCHAR2	(240)
SOLDBY_CONTACT_EMAILID	VARCHAR2	(240)
SOLDBY_CONTACT_PHONENUMBER	VARCHAR2	(60)

Query Text

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


SELECT DELIVERY_ID
,      SOURCE_CODE
,      ORDER_HEADER_ID
,      SOLDTO_CUSTOMER_ID
,      SOLDTO_CONTACT_ID
,      SOLDTO_ADDRESS_ID
,      SOLDTO_CODE_INT
,      SOLDTO_NAME
,      SOLDTO_ADDRESS1
,      SOLDTO_ADDRESS2
,      SOLDTO_ADDRESS3
,      SOLDTO_ADDRESS4
,      SOLDTO_CITY
,      SOLDTO_POSTAL_CODE
,      SOLDTO_COUNTRY_INT
,      SOLDTO_STATE_INT
,      SOLDTO_PROVINCE_INT
,      SOLDTO_COUNTY
,      SOLDTO_CONT_NAME
,      SOLDTO_CONT_JOB_TITLE
,      SOLDTO_CONT_EMAIL
,      SOLDTO_CONT_COUNTRY_CODE
,      SOLDTO_CONT_AREA_CODE
,      SOLDTO_CONT_PHONE_NUMBER
,      SOLDTO_CONT_PHONE_EXTN
,      SOLDBY_LOCATION_CODE
,      SOLDBY_COUNTRY
,      SOLDBY_ADDRESS_LINE_1
,      SOLDBY_ADDRESS_LINE_2
,      SOLDBY_ADDRESS_LINE_3
,      SOLDBY_ADDRESS_LINE_4
,      SOLDBY_COUNTY
,      SOLDBY_STATE
,      SOLDBY_POSTAL_CODE
,      SOLDBY_CITY
,      SOLDBY_ORGANIZATION_ID
,      SOLDBY_NAME
,      SOLDBY_CONTACT_NAME
,      SOLDBY_CONTACT_EMAILID
,      SOLDBY_CONTACT_PHONENUMBER
FROM APPS.WSH_OPSM_ASN_ORDERS_COMM_V;

Dependencies

[top of page]

APPS.WSH_OPSM_ASN_ORDERS_COMM_V references the following:

APPS: HR_API - show dependent code; HR_GENERAL - show dependent code; HR_LOCATIONS_ALL; HR_ORGANIZATION_UNITS_V; HR_SECURITY - show dependent code; 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; PER_ALL_PEOPLE_F; PER_PHONES; WSH_DELIVERY_ASSIGNMENTS; WSH_DELIVERY_DETAILS; WSH_LOCATIONS

APPS.WSH_OPSM_ASN_ORDERS_COMM_V is referenced by following:

APPS: WSH_OPSM_ASN_DELIVERIES_V