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

VIEW: APPS.AR_PAY_SITE_USES_S_V

Object Details
Object Name: AR_PAY_SITE_USES_S_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.AR_PAY_SITE_USES_S_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
Name Datatype Length Mandatory Comments
PAY_SITE_CUST_ACCT_SITE_ID NUMBER (15) Yes Customer site identifier
PAY_SITE_TRNSL_CUST_NAME VARCHAR2 (50)
Translated customer name
PAY_SITE_GSA_INDICATOR VARCHAR2 (1)
Indicates if this is a US federal agency supported by the General Services Administration (GSA). Y for organizations served by the GSA, N for organizations that are not served by the GSA.
PAY_SITE_LOCATION VARCHAR2 (40) Yes Site use identifier
PAY_SITE_SITE_USE_CODE VARCHAR2 (30) Yes Business purpose assigned to customer site account, such as Bill-To, Market, and Statements.
PAY_SITE_SITE_USE_ID NUMBER (15) Yes Site use identifier
PAY_SITE_TAX_REFERENCE VARCHAR2 (50)
Taxpayer identification number
PAY_TERRITORY_DESCRIPTION VARCHAR2 (240)
Description of the territory
PAY_TERRITORY_NAME VARCHAR2 (40)
Territory name
PAY_TERRITORY_SEGMENT1 VARCHAR2 (25)
Key flexfield segment
PAY_TERRITORY_SEGMENT10 VARCHAR2 (25)
Key flexfield segment
PAY_TERRITORY_SEGMENT11 VARCHAR2 (25)
Key flexfield segment
PAY_TERRITORY_SEGMENT12 VARCHAR2 (25)
Key flexfield segment
PAY_TERRITORY_SEGMENT13 VARCHAR2 (25)
Key flexfield segment
PAY_TERRITORY_SEGMENT14 VARCHAR2 (25)
Key flexfield segment
PAY_TERRITORY_SEGMENT15 VARCHAR2 (25)
Key flexfield segment
PAY_TERRITORY_SEGMENT16 VARCHAR2 (25)
Key flexfield segment
PAY_TERRITORY_SEGMENT17 VARCHAR2 (25)
Key flexfield segment
PAY_TERRITORY_SEGMENT18 VARCHAR2 (25)
Key flexfield segment
PAY_TERRITORY_SEGMENT19 VARCHAR2 (25)
Key flexfield segment
PAY_TERRITORY_SEGMENT2 VARCHAR2 (25)
Key flexfield segment
PAY_TERRITORY_SEGMENT20 VARCHAR2 (25)
Key flexfield segment
PAY_TERRITORY_SEGMENT3 VARCHAR2 (25)
Key flexfield segment
PAY_TERRITORY_SEGMENT4 VARCHAR2 (25)
Key flexfield segment
PAY_TERRITORY_SEGMENT5 VARCHAR2 (25)
Key flexfield segment
PAY_TERRITORY_SEGMENT6 VARCHAR2 (25)
Key flexfield segment
PAY_TERRITORY_SEGMENT7 VARCHAR2 (25)
Key flexfield segment
PAY_TERRITORY_SEGMENT8 VARCHAR2 (25)
Key flexfield segment
PAY_TERRITORY_SEGMENT9 VARCHAR2 (25)
Key flexfield segment
PAY_TERRITORY_ID NUMBER (15)
Unique identifier
PAY_SITE_CUST_CAT_CODE VARCHAR2 (30)
User-definable category. The lookup type is CUSTOMER_CATEGORY.
PAY_SITE_GLOBAL_ATTR1 VARCHAR2 (150)
Reserved for country-specific functionality
PAY_SITE_GLOBAL_ATTR2 VARCHAR2 (150)
Reserved for country-specific functionality
PAY_SITE_GLOBAL_ATTR3 VARCHAR2 (150)
Reserved for country-specific functionality
PAY_SITE_GLOBAL_ATTR4 VARCHAR2 (150)
Reserved for country-specific functionality
PAY_SITE_GLOBAL_ATTR5 VARCHAR2 (150)
Reserved for country-specific functionality
PAY_SITE_GLOBAL_ATTR6 VARCHAR2 (150)
Reserved for country-specific functionality
PAY_SITE_GLOBAL_ATTR7 VARCHAR2 (150)
Reserved for country-specific functionality
PAY_SITE_GLOBAL_ATTR8 VARCHAR2 (150)
Reserved for country-specific functionality
PAY_SITE_GLOBAL_ATTR9 VARCHAR2 (150)
Reserved for country-specific functionality
PAY_SITE_GLOBAL_ATTR_CAT VARCHAR2 (30)
Reserved for country-specific functionality
PAY_SITE_PARTY_SITE_ID NUMBER (15) Yes Identifier for a party site. Foreign key to the HZ_PARTY_SITES table
EVENT_ID NUMBER (15)
LINE_NUMBER NUMBER (15)
LEDGER_ID NUMBER (15)
Query Text

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


SELECT PAY_SITE_CUST_ACCT_SITE_ID
,      PAY_SITE_TRNSL_CUST_NAME
,      PAY_SITE_GSA_INDICATOR
,      PAY_SITE_LOCATION
,      PAY_SITE_SITE_USE_CODE
,      PAY_SITE_SITE_USE_ID
,      PAY_SITE_TAX_REFERENCE
,      PAY_TERRITORY_DESCRIPTION
,      PAY_TERRITORY_NAME
,      PAY_TERRITORY_SEGMENT1
,      PAY_TERRITORY_SEGMENT10
,      PAY_TERRITORY_SEGMENT11
,      PAY_TERRITORY_SEGMENT12
,      PAY_TERRITORY_SEGMENT13
,      PAY_TERRITORY_SEGMENT14
,      PAY_TERRITORY_SEGMENT15
,      PAY_TERRITORY_SEGMENT16
,      PAY_TERRITORY_SEGMENT17
,      PAY_TERRITORY_SEGMENT18
,      PAY_TERRITORY_SEGMENT19
,      PAY_TERRITORY_SEGMENT2
,      PAY_TERRITORY_SEGMENT20
,      PAY_TERRITORY_SEGMENT3
,      PAY_TERRITORY_SEGMENT4
,      PAY_TERRITORY_SEGMENT5
,      PAY_TERRITORY_SEGMENT6
,      PAY_TERRITORY_SEGMENT7
,      PAY_TERRITORY_SEGMENT8
,      PAY_TERRITORY_SEGMENT9
,      PAY_TERRITORY_ID
,      PAY_SITE_CUST_CAT_CODE
,      PAY_SITE_GLOBAL_ATTR1
,      PAY_SITE_GLOBAL_ATTR2
,      PAY_SITE_GLOBAL_ATTR3
,      PAY_SITE_GLOBAL_ATTR4
,      PAY_SITE_GLOBAL_ATTR5
,      PAY_SITE_GLOBAL_ATTR6
,      PAY_SITE_GLOBAL_ATTR7
,      PAY_SITE_GLOBAL_ATTR8
,      PAY_SITE_GLOBAL_ATTR9
,      PAY_SITE_GLOBAL_ATTR_CAT
,      PAY_SITE_PARTY_SITE_ID
,      EVENT_ID
,      LINE_NUMBER
,      LEDGER_ID
FROM APPS.AR_PAY_SITE_USES_S_V;

Dependencies

[top of page]

APPS.AR_PAY_SITE_USES_S_V references the following:

SchemaAPPS
SynonymAR_XLA_LINES_EXTRACT
SynonymHZ_CUST_ACCT_SITES_ALL
SynonymHZ_CUST_SITE_USES_ALL
SynonymRA_TERRITORIES

APPS.AR_PAY_SITE_USES_S_V is not referenced by any database object