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

VIEW: APPS.OZF_SD_BILL_TO_CUST_V

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

View Type

A Business Intelligence System view


Contains information about customer who is billed.


[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
CATEGORY_CODE VARCHAR2 (30)
category code
EMAIL_ADDRESS VARCHAR2 (2000)
Email address of the customer who is billed
PHONE_NUMBER VARCHAR2 (40)
Phone number of the customer who is billed
LOCATION_ID NUMBER

Bill to customer location
CUST_ADD1 VARCHAR2 (240)
First line of the physical address
CUST_ADD2 VARCHAR2 (240)
Second line of the physical address
CUST_ADD3 VARCHAR2 (240)
Third line of the physical address
CUST_CITY VARCHAR2 (60)
city name
CUST_COUNTRY VARCHAR2 (60)
Country where the customer is located
CUST_POSTAL_CODE VARCHAR2 (60)
zip code
CUST_PO_BOX VARCHAR2 (50)
PO Box identifer
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_BILL_TO_CUST_V;

Dependencies

[top of page]

APPS.OZF_SD_BILL_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_BILL_TO_CUST_V is not referenced by any database object