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

VIEW: APPS.CS_CP_BILLTOADD_RG_V

Object Details
Object Name: CS_CP_BILLTOADD_RG_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCS.CS_CP_BILLTOADD_RG_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ACCOUNT_NUMBER VARCHAR2 (30) Yes Bill to account number
LOCATION NUMBER (15) Yes Billed to location
DESCRIPTION VARCHAR2 (2000)
Billed to location description
PARTY_NAME VARCHAR2 (360) Yes Billed to party name
PARTY_SITE_NAME VARCHAR2 (240)
Bill to party site name
ADDRESS1 VARCHAR2 (240) Yes Bill to address information
ADDRESS2 VARCHAR2 (240)
Bill to address information
ADDRESS3 VARCHAR2 (240)
Bill to address information
ADDRESS4 VARCHAR2 (240)
Bill to address information
CITY VARCHAR2 (60)
Bill to address information
STATE VARCHAR2 (60)
Bill to address information
ZIP VARCHAR2 (60)
Bill to address information
COUNTRY VARCHAR2 (60) Yes Bill to address information
Query Text

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


SELECT ACCOUNT_NUMBER
,      LOCATION
,      DESCRIPTION
,      PARTY_NAME
,      PARTY_SITE_NAME
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      STATE
,      ZIP
,      COUNTRY
FROM APPS.CS_CP_BILLTOADD_RG_V;

Dependencies

[top of page]

APPS.CS_CP_BILLTOADD_RG_V references the following:

SchemaAPPS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_LOCATIONS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES

APPS.CS_CP_BILLTOADD_RG_V is not referenced by any database object