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

VIEW: APPS.CSP_RS_SHIP_TO_ADDRESSES_V

Object Details
Object Name: CSP_RS_SHIP_TO_ADDRESSES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSP.CSP_RS_SHIP_TO_ADDRESSES_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
RESOURCE_TYPE VARCHAR2 (30) Yes Resource type
RESOURCE_ID NUMBER (35) Yes Resource identifier
CUSTOMER_ID NUMBER (35)
Customer identifier
CUST_ACCT_SITE_ID NUMBER (15) Yes Customer account site identifier
PARTY_SITE_ID NUMBER (15) Yes Party site identifier
SITE_USE_ID NUMBER (15)
Site use identifier
SITE_USE_CODE VARCHAR2 (30)
Site use code
PRIMARY_FLAG VARCHAR2 (1)
Primary address flag
STATUS VARCHAR2 (1)
Status (A - Active I-Inactive)
INV_LOC_ID NUMBER
Yes Inventory location identifier
ENTERED_BY NUMBER (15) Yes Entered by
ROW_ID ROWID (10)
Row identifier
LOCATION_CODE VARCHAR2 (60) Yes Location code
DESCRIPTION VARCHAR2 (240)
Description
STYLE VARCHAR2 (7)
Address style code
ADDRESS_STYLE VARCHAR2 (80)
Address style
ADDRESS_LINE_1 VARCHAR2 (240)
Address line 1
ADDRESS_LINE_2 VARCHAR2 (240)
Address line 2
ADDRESS_LINE_3 VARCHAR2 (240)
Address line 3
TOWN_OR_CITY VARCHAR2 (30)
Town or city
COUNTRY VARCHAR2 (60)
Country
POSTAL_CODE VARCHAR2 (30)
Postal code
REGION_1 VARCHAR2 (120)
Region 1
REGION_2 VARCHAR2 (120)
Region 2
REGION_3 VARCHAR2 (120)
Region 3
BILL_TO_SITE_FLAG VARCHAR2 (30)
Bill to site flag
DESIGNATED_RECEIVER_ID NUMBER (15)
Designated receiver identifier
IN_ORGANIZATION_FLAG VARCHAR2 (30)
In organization flag
INACTIVE_DATE DATE

Inactive date
INVENTORY_ORGANIZATION_ID NUMBER (15)
Inventory organization identifier
OFFICE_SITE_FLAG VARCHAR2 (30)
Office site flag
RECEIVING_SITE_FLAG VARCHAR2 (30)
Receiving site flag
SHIP_TO_LOCATION_ID NUMBER (15)
Ship to location identifier
SHIP_TO_LOCATION VARCHAR2 (60)
Ship to location
SHIP_TO_SITE_FLAG VARCHAR2 (30)
Ship to site flag
TAX_NAME VARCHAR2 (15)
Tax name
TELEPHONE_NUMBER_1 VARCHAR2 (60)
Telephone number 1
TELEPHONE_NUMBER_2 VARCHAR2 (60)
Telephone number 2
TELEPHONE_NUMBER_3 VARCHAR2 (60)
Telephone number 3
LOC_INFORMATION13 VARCHAR2 (150)
Location information 13
LOC_INFORMATION14 VARCHAR2 (150)
Location information 14
LOC_INFORMATION15 VARCHAR2 (150)
Location information 15
LOC_INFORMATION16 VARCHAR2 (150)
Location information 16
LOC_INFORMATION17 VARCHAR2 (150)
Location information 17
LOC_INFORMATION18 VARCHAR2 (150)
Location information 18
LOC_INFORMATION19 VARCHAR2 (150)
Location information 19
LOC_INFORMATION20 VARCHAR2 (150)
Location information 20
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER (15)
Standard Who Column - with the user id from FND_USER
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
CREATED_BY NUMBER (15)
Standard Who Column - with the user id from FND_USER
CREATION_DATE DATE

Standard Who Column
OBJECT_VERSION_NUMBER NUMBER (9)
Object version number
TP_HEADER_ID NUMBER

TP header identifier
ECE_TP_LOCATION_CODE VARCHAR2 (35)
ECE TP location code
SITE_LOC_ID NUMBER (15) Yes Site location identifier
TIMEZONE_ID VARCHAR2 (50)
Timezone identifier
TIMEZONE_NAME VARCHAR2 (80)
Timezone name
GLOBAL_TIMEZONE_NAME VARCHAR2 (50)
Global timezone name
ATTRIBUTE1 VARCHAR2 (150)
Attribute1 for HR_LOCATIONS flex field
ATTRIBUTE2 VARCHAR2 (150)
Attribute2 for HR_LOCATIONS flex field
ATTRIBUTE3 VARCHAR2 (150)
Attribute3 for HR_LOCATIONS flex field
ATTRIBUTE4 VARCHAR2 (150)
Attribute4 for HR_LOCATIONS flexfield
ATTRIBUTE5 VARCHAR2 (150)
Attribute5 for HR_LOCATIONS flexfield
ATTRIBUTE6 VARCHAR2 (150)
Attribute6 for HR_LOCATIONS flexfield
ATTRIBUTE7 VARCHAR2 (150)
Attribute7 for HR_LOCATIONS flexfield
ATTRIBUTE8 VARCHAR2 (150)
Attribute8 for HR_LOCATIONS flexfield
ATTRIBUTE9 VARCHAR2 (150)
Attribute9 for HR_LOCATIONS flexfield
ATTRIBUTE10 VARCHAR2 (150)
Attribute10 for HR_LOCATIONS flexfield
ATTRIBUTE11 VARCHAR2 (150)
Attribute11 for HR_LOCATIONS flexfield
ATTRIBUTE12 VARCHAR2 (150)
Attribute12 for HR_LOCATIONS flexfield
ATTRIBUTE13 VARCHAR2 (150)
Attribute13 for HR_LOCATIONS flexfield
ATTRIBUTE14 VARCHAR2 (150)
Attribute14 for HR_LOCATIONS flexfield
ATTRIBUTE15 VARCHAR2 (150)
Attribute15 for HR_LOCATIONS flexfield
ATTRIBUTE16 VARCHAR2 (150)
Attribute16 for HR_LOCATIONS flexfield
ATTRIBUTE17 VARCHAR2 (150)
Attribute17 for HR_LOCATIONS flexfield
ATTRIBUTE18 VARCHAR2 (150)
Attribute18 for HR_LOCATIONS flexfield
ATTRIBUTE19 VARCHAR2 (150)
Attribute19 for HR_LOCATIONS flexfield
ATTRIBUTE20 VARCHAR2 (150)
Attribute20 for HR_LOCATIONS flexfield
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute category
Query Text

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


SELECT RESOURCE_TYPE
,      RESOURCE_ID
,      CUSTOMER_ID
,      CUST_ACCT_SITE_ID
,      PARTY_SITE_ID
,      SITE_USE_ID
,      SITE_USE_CODE
,      PRIMARY_FLAG
,      STATUS
,      INV_LOC_ID
,      ENTERED_BY
,      ROW_ID
,      LOCATION_CODE
,      DESCRIPTION
,      STYLE
,      ADDRESS_STYLE
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      TOWN_OR_CITY
,      COUNTRY
,      POSTAL_CODE
,      REGION_1
,      REGION_2
,      REGION_3
,      BILL_TO_SITE_FLAG
,      DESIGNATED_RECEIVER_ID
,      IN_ORGANIZATION_FLAG
,      INACTIVE_DATE
,      INVENTORY_ORGANIZATION_ID
,      OFFICE_SITE_FLAG
,      RECEIVING_SITE_FLAG
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION
,      SHIP_TO_SITE_FLAG
,      TAX_NAME
,      TELEPHONE_NUMBER_1
,      TELEPHONE_NUMBER_2
,      TELEPHONE_NUMBER_3
,      LOC_INFORMATION13
,      LOC_INFORMATION14
,      LOC_INFORMATION15
,      LOC_INFORMATION16
,      LOC_INFORMATION17
,      LOC_INFORMATION18
,      LOC_INFORMATION19
,      LOC_INFORMATION20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      TP_HEADER_ID
,      ECE_TP_LOCATION_CODE
,      SITE_LOC_ID
,      TIMEZONE_ID
,      TIMEZONE_NAME
,      GLOBAL_TIMEZONE_NAME
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE_CATEGORY
FROM APPS.CSP_RS_SHIP_TO_ADDRESSES_V;

Dependencies

[top of page]

APPS.CSP_RS_SHIP_TO_ADDRESSES_V references the following:

SchemaAPPS
SynonymCSP_RS_CUST_RELATIONS
PL/SQL PackageHR_API - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS_V
SynonymHZ_CUST_ACCT_SITES
SynonymHZ_CUST_SITE_USES
SynonymHZ_LOCATIONS
SynonymHZ_PARTY_SITES
ViewHZ_TIMEZONES_VL
SynonymPO_LOCATION_ASSOCIATIONS
APPS.CSP_RS_SHIP_TO_ADDRESSES_V is referenced by following:

SchemaAPPS
Package BodyCSP_SCH_INT_PVT - show dependent code
Package BodyCSP_SHIP_TO_ADDRESS_PVT - show dependent code