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

VIEW: APPS.OZF_SD_RES_SHIP_TO_CUST_V

Object Details
Object Name: OZF_SD_RES_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 Inbound flow.


[View Source]

Columns
Name Datatype Length Mandatory Comments
RES_CUST_INTF_ID NUMBER
Yes unique identifier
CUSTNAME VARCHAR2 (360)
Customer Name
CUST_DUNS_NUMBER VARCHAR2 (100)
DUNS Number of the customer
CUST_CAT_CODE VARCHAR2 (100)
Category code for customer
CUST_EMAIL VARCHAR2 (2000)
Customer email
CUST_TEL_NUMBER VARCHAR2 (60)
Customer telephone number
PRTCCODE VARCHAR2 (30)
Partner classification code for customer
PADD_ADD1 VARCHAR2 (240)
Physical address1
PADD_ADD2 VARCHAR2 (240)
Physical address2
PADD_ADD3 VARCHAR2 (240)
Physical address3
PADD_CITY VARCHAR2 (60)
city name
PADD_COUNTRY VARCHAR2 (60)
country
PADD_POSTAL_CODE VARCHAR2 (60)
zip code
PADD_PO_BOX VARCHAR2 (60)
PO Box identifier
REQUEST_NUMBER VARCHAR2 (30)
request number
SITE_USE_CODE VARCHAR2 (30)
site use code
Query Text

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


SELECT RES_CUST_INTF_ID
,      CUSTNAME
,      CUST_DUNS_NUMBER
,      CUST_CAT_CODE
,      CUST_EMAIL
,      CUST_TEL_NUMBER
,      PRTCCODE
,      PADD_ADD1
,      PADD_ADD2
,      PADD_ADD3
,      PADD_CITY
,      PADD_COUNTRY
,      PADD_POSTAL_CODE
,      PADD_PO_BOX
,      REQUEST_NUMBER
,      SITE_USE_CODE
FROM APPS.OZF_SD_RES_SHIP_TO_CUST_V;

Dependencies

[top of page]

APPS.OZF_SD_RES_SHIP_TO_CUST_V references the following:

SchemaAPPS
SynonymOZF_SD_RES_CUST_INTF

APPS.OZF_SD_RES_SHIP_TO_CUST_V is not referenced by any database object