DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OZF_SD_SHIP_TO_CUST_V

Object Details
Object Name: OZF_SD_SHIP_TO_CUST_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Stores details about customers whom the products are shipped. Used in Outbound flow.


[View Source]

Columns
Name Datatype Length Mandatory Comments
REQUEST_HEADER_ID NUMBER
Yes Request header ID
CUST_NAME VARCHAR2 (360)
Customer name
DUNS_NUMBER NUMBER

DUNS Number of the customer
CATEGORY_CODE VARCHAR2 (30)
Category code for customer
EMAIL_ADDRESS VARCHAR2 (2000)
Customer email
PHONE_NUMBER VARCHAR2 (40)
Customer telephone number
LOCATION_ID NUMBER

Location ID of the customer
CUST_ADD1 VARCHAR2 (240)
Customer Address1
CUST_ADD2 VARCHAR2 (240)
Customer Address2
CUST_ADD3 VARCHAR2 (240)
Customer Address3
CUST_CITY VARCHAR2 (60)
city name
CUST_COUNTRY VARCHAR2 (60)
country
CUST_POSTAL_CODE VARCHAR2 (60)
zip code
CUST_PO_BOX VARCHAR2 (50)
PO Box identifier
SITE_USE_CODE VARCHAR2 (30)
site use code
Query Text

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


SELECT REQUEST_HEADER_ID
,      CUST_NAME
,      DUNS_NUMBER
,      CATEGORY_CODE
,      EMAIL_ADDRESS
,      PHONE_NUMBER
,      LOCATION_ID
,      CUST_ADD1
,      CUST_ADD2
,      CUST_ADD3
,      CUST_CITY
,      CUST_COUNTRY
,      CUST_POSTAL_CODE
,      CUST_PO_BOX
,      SITE_USE_CODE
FROM APPS.OZF_SD_SHIP_TO_CUST_V;

Dependencies

[top of page]

APPS.OZF_SD_SHIP_TO_CUST_V references the following:

SchemaAPPS
SynonymHZ_CUST_ACCT_SITES
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_LOCATIONS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
SynonymOZF_SD_CUSTOMER_DETAILS

APPS.OZF_SD_SHIP_TO_CUST_V is not referenced by any database object