[Home] [Help] [Dependency Information]

VIEW: APPS.CSI_CP_FORM_ADDRESS_V

Object Details

Object Name:	CSI_CP_FORM_ADDRESS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSI.CSI_CP_FORM_ADDRESS_V
Subobject Name:
Status:	VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Query Text

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

SELECT ROW_ID
,      CUSTOMER_PRODUCT_ID
,      CP_OBJECT_VERSION_NUMBER
,      INSTANCE_PARTY_ID
,      IP_OBJECT_VERSION_NUMBER
,      IP_ACCOUNT_ID
,      SHIP_TO_SITE_USE_ID
,      BILL_TO_SITE_USE_ID
,      IPA_OBJECT_VERSION_NUMBER
,      SHIP_TO_PARTY_SITE_NAME
,      SHIP_TO_PARTY_ID
,      SHIP_TO_PARTY_NAME
,      SHIP_TO_PARTY_TYPE
,      SHIP_TO_PARTY_LAST_NAME
,      SHIP_TO_PARTY_FIRST_NAME
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION_DESC
,      SHIP_TO_ADDRESS1
,      SHIP_TO_ADDRESS2
,      SHIP_TO_ADDRESS3
,      SHIP_TO_ADDRESS4
,      SHIP_TO_MAILSTOP
,      SHIP_TO_CITY
,      SHIP_TO_POSTAL_CODE
,      SHIP_TO_STATE
,      SHIP_TO_PROVINCE
,      SHIP_TO_COUNTY
,      SHIP_TO_COUNTRY
,      INSTALL_TO_PARTY_SITE_NAME
,      INSTALL_TO_PARTY_ID
,      INSTALL_TO_PARTY_NAME
,      INSTALL_TO_PARTY_TYPE
,      INSTALL_TO_PARTY_LAST_NAME
,      INSTALL_TO_PARTY_FIRST_NAME
,      INSTALL_TO_LOCATION_ID
,      INSTALL_TO_LOCATION_DESC
,      INSTALL_TO_ADDRESS1
,      INSTALL_TO_ADDRESS2
,      INSTALL_TO_ADDRESS3
,      INSTALL_TO_ADDRESS4
,      INSTALL_TO_MAILSTOP
,      INSTALL_TO_CITY
,      INSTALL_TO_POSTAL_CODE
,      INSTALL_TO_STATE
,      INSTALL_TO_PROVINCE
,      INSTALL_TO_COUNTY
,      INSTALL_TO_COUNTRY
,      BILL_TO_PARTY_SITE_NAME
,      BILL_TO_PARTY_ID
,      BILL_TO_PARTY_NAME
,      BILL_TO_PARTY_TYPE
,      BILL_TO_PARTY_LAST_NAME
,      BILL_TO_PARTY_FIRST_NAME
,      BILL_TO_LOCATION_ID
,      BILL_TO_LOCATION_DESC
,      BILL_TO_ADDRESS1
,      BILL_TO_ADDRESS2
,      BILL_TO_ADDRESS3
,      BILL_TO_ADDRESS4
,      BILL_TO_MAILSTOP
,      BILL_TO_CITY
,      BILL_TO_POSTAL_CODE
,      BILL_TO_STATE
,      BILL_TO_PROVINCE
,      BILL_TO_COUNTY
,      BILL_TO_COUNTRY
,      SHIP_TO_PARTY_SITE_NUMBER
,      INSTALL_TO_PARTY_SITE_NUMBER
,      BILL_TO_PARTY_SITE_NUMBER
,      PARTY_ID
FROM APPS.CSI_CP_FORM_ADDRESS_V;

Dependencies

[top of page]

APPS

CSI_INSTALL_PARAMETERS

CSI_IPA_RELATION_TYPES

CSI_IP_ACCOUNTS

CSI_ITEM_INSTANCES

CSI_I_PARTIES

HZ_CUST_ACCOUNTS

HZ_CUST_ACCT_SITES_ALL

HZ_CUST_SITE_USES_ALL

HZ_LOCATIONS

HZ_PARTIES

HZ_PARTY_SITES

APPS.CSI_CP_FORM_ADDRESS_V is not referenced by any database object