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

VIEW: APPS.AR_BILL_TO_SITE_USES_S_V

Object Details
Object Name: AR_BILL_TO_SITE_USES_S_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.AR_BILL_TO_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
BILL_SITE_CUST_CAT_CODE VARCHAR2 (30)
User-definable category. The lookup type is CUSTOMER_CATEGORY.
BILL_SITE_CUST_ACCT_SITE_ID NUMBER (15) Yes Customer site identifier
BILL_SITE_GLOBAL_ATTR1 VARCHAR2 (150)
Reserved for country-specific functionality
BILL_SITE_GLOBAL_ATTR2 VARCHAR2 (150)
Reserved for country-specific functionality
BILL_SITE_GLOBAL_ATTR3 VARCHAR2 (150)
Reserved for country-specific functionality
BILL_SITE_GLOBAL_ATTR4 VARCHAR2 (150)
Reserved for country-specific functionality
BILL_SITE_GLOBAL_ATTR5 VARCHAR2 (150)
Reserved for country-specific functionality
BILL_SITE_GLOBAL_ATTR6 VARCHAR2 (150)
Reserved for country-specific functionality
BILL_SITE_GLOBAL_ATTR7 VARCHAR2 (150)
Reserved for country-specific functionality
BILL_SITE_GLOBAL_ATTR8 VARCHAR2 (150)
Reserved for country-specific functionality
BILL_SITE_GLOBAL_ATTR9 VARCHAR2 (150)
Reserved for country-specific functionality
BILL_SITE_GLOBAL_ATTR_CAT VARCHAR2 (30)
Reserved for country-specific functionality
BILL_SITE_TRNSL_CUST_NAME VARCHAR2 (50)
Translated customer name
BILL_USES_GLOBAL_ATTR1 VARCHAR2 (150)
Reserved for country-specific functionality
BILL_USES_GLOBAL_ATTR_CAT VARCHAR2 (30)
Reserved for country-specific functionality
BILL_USES_CLEARING_CCID NUMBER (15)
Code combination ID for the Clearing Account
BILL_USES_FREIGHT_CCID NUMBER (15)
Code combination ID for the Freight Account
BILL_USES_REC_CCID NUMBER (15)
Code combination ID for the Receivable Account
BILL_USES_REV_CCID NUMBER (15)
Code combination ID for the Revenue Account
BILL_USES_TAX_CCID NUMBER (15)
Code combination ID for the Tax Account
BILL_USES_UNBILLED_CCID NUMBER (15)
Code combination ID for the Unbilled Account
BILL_USES_UNEARNED_CCID NUMBER (15)
Code combination ID for the Unearned Account
BILL_USES_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.
BILL_USES_LOCATION VARCHAR2 (40) Yes Site use identifier
BILL_USES_SITE_USE_CODE VARCHAR2 (30) Yes Business purpose assigned to customer site account, such as Bill-To, Market, and Statements.
BILL_USES_SITE_USE_ID NUMBER (15) Yes Site use identifier
BILL_USES_TAX_REFERENCE VARCHAR2 (50)
Taxpayer identification number
BILL_TERRITORY_DESCRIPTION VARCHAR2 (240)
Description of the territory
BILL_TERRITORY_NAME VARCHAR2 (40)
Territory name
BILL_TERRITORY_SEGMENT1 VARCHAR2 (25)
Key flexfield segment
BILL_TERRITORY_SEGMENT10 VARCHAR2 (25)
Key flexfield segment
BILL_TERRITORY_SEGMENT11 VARCHAR2 (25)
Key flexfield segment
BILL_TERRITORY_SEGMENT12 VARCHAR2 (25)
Key flexfield segment
BILL_TERRITORY_SEGMENT13 VARCHAR2 (25)
Key flexfield segment
BILL_TERRITORY_SEGMENT14 VARCHAR2 (25)
Key flexfield segment
BILL_TERRITORY_SEGMENT15 VARCHAR2 (25)
Key flexfield segment
BILL_TERRITORY_SEGMENT16 VARCHAR2 (25)
Key flexfield segment
BILL_TERRITORY_SEGMENT17 VARCHAR2 (25)
Key flexfield segment
BILL_TERRITORY_SEGMENT18 VARCHAR2 (25)
Key flexfield segment
BILL_TERRITORY_SEGMENT19 VARCHAR2 (25)
Key flexfield segment
BILL_TERRITORY_SEGMENT2 VARCHAR2 (25)
Key flexfield segment
BILL_TERRITORY_SEGMENT20 VARCHAR2 (25)
Key flexfield segment
BILL_TERRITORY_SEGMENT3 VARCHAR2 (25)
Key flexfield segment
BILL_TERRITORY_SEGMENT4 VARCHAR2 (25)
Key flexfield segment
BILL_TERRITORY_SEGMENT5 VARCHAR2 (25)
Key flexfield segment
BILL_TERRITORY_SEGMENT6 VARCHAR2 (25)
Key flexfield segment
BILL_TERRITORY_SEGMENT7 VARCHAR2 (25)
Key flexfield segment
BILL_TERRITORY_SEGMENT8 VARCHAR2 (25)
Key flexfield segment
BILL_TERRITORY_SEGMENT9 VARCHAR2 (25)
Key flexfield segment
BILL_TERRITORY_ID NUMBER (15)
Unique identifier
BILL_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 BILL_SITE_CUST_CAT_CODE
,      BILL_SITE_CUST_ACCT_SITE_ID
,      BILL_SITE_GLOBAL_ATTR1
,      BILL_SITE_GLOBAL_ATTR2
,      BILL_SITE_GLOBAL_ATTR3
,      BILL_SITE_GLOBAL_ATTR4
,      BILL_SITE_GLOBAL_ATTR5
,      BILL_SITE_GLOBAL_ATTR6
,      BILL_SITE_GLOBAL_ATTR7
,      BILL_SITE_GLOBAL_ATTR8
,      BILL_SITE_GLOBAL_ATTR9
,      BILL_SITE_GLOBAL_ATTR_CAT
,      BILL_SITE_TRNSL_CUST_NAME
,      BILL_USES_GLOBAL_ATTR1
,      BILL_USES_GLOBAL_ATTR_CAT
,      BILL_USES_CLEARING_CCID
,      BILL_USES_FREIGHT_CCID
,      BILL_USES_REC_CCID
,      BILL_USES_REV_CCID
,      BILL_USES_TAX_CCID
,      BILL_USES_UNBILLED_CCID
,      BILL_USES_UNEARNED_CCID
,      BILL_USES_GSA_INDICATOR
,      BILL_USES_LOCATION
,      BILL_USES_SITE_USE_CODE
,      BILL_USES_SITE_USE_ID
,      BILL_USES_TAX_REFERENCE
,      BILL_TERRITORY_DESCRIPTION
,      BILL_TERRITORY_NAME
,      BILL_TERRITORY_SEGMENT1
,      BILL_TERRITORY_SEGMENT10
,      BILL_TERRITORY_SEGMENT11
,      BILL_TERRITORY_SEGMENT12
,      BILL_TERRITORY_SEGMENT13
,      BILL_TERRITORY_SEGMENT14
,      BILL_TERRITORY_SEGMENT15
,      BILL_TERRITORY_SEGMENT16
,      BILL_TERRITORY_SEGMENT17
,      BILL_TERRITORY_SEGMENT18
,      BILL_TERRITORY_SEGMENT19
,      BILL_TERRITORY_SEGMENT2
,      BILL_TERRITORY_SEGMENT20
,      BILL_TERRITORY_SEGMENT3
,      BILL_TERRITORY_SEGMENT4
,      BILL_TERRITORY_SEGMENT5
,      BILL_TERRITORY_SEGMENT6
,      BILL_TERRITORY_SEGMENT7
,      BILL_TERRITORY_SEGMENT8
,      BILL_TERRITORY_SEGMENT9
,      BILL_TERRITORY_ID
,      BILL_SITE_PARTY_SITE_ID
,      EVENT_ID
,      LINE_NUMBER
,      LEDGER_ID
FROM APPS.AR_BILL_TO_SITE_USES_S_V;

Dependencies

[top of page]

APPS.AR_BILL_TO_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_BILL_TO_SITE_USES_S_V is referenced by following:

SchemaAPPS
Package BodyXLA_00222_AAD_S_000002_PKG - show dependent code
Package BodyXLA_00222_AAD_S_000005_PKG - show dependent code
Package BodyXLA_00222_AAD_S_000006_PKG - show dependent code
Package BodyXLA_00222_AAD_S_000007_PKG - show dependent code
Package BodyXLA_00222_AAD_S_000008_PKG - show dependent code
Package BodyXLA_00222_AAD_S_000009_PKG - show dependent code
Package BodyXLA_00222_AAD_S_000017_PKG - show dependent code