[Home] [Help]
[Dependency Information]
Object Name: | AR_RCT_SITE_USES_H_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RCT_SITE_CUST_ACCT_SITE_ID | NUMBER | (15) | Yes | |
RCT_SITE_TRNSL_CUST_NAME | VARCHAR2 | (50) | ||
RCT_SITE_GSA_INDICATOR | VARCHAR2 | (1) | ||
RCT_SITE_LOCATION | VARCHAR2 | (40) | Yes | |
RCT_SITE_SITE_USE_CODE | VARCHAR2 | (30) | Yes | |
RCT_SITE_SITE_USE_ID | NUMBER | (15) | Yes | |
RCT_SITE_TAX_REFERENCE | VARCHAR2 | (50) | ||
RCT_TERRITORY_DESCRIPTION | VARCHAR2 | (240) | ||
RCT_TERRITORY_NAME | VARCHAR2 | (40) | ||
RCT_TERRITORY_SEGMENT1 | VARCHAR2 | (25) | ||
RCT_TERRITORY_SEGMENT10 | VARCHAR2 | (25) | ||
RCT_TERRITORY_SEGMENT11 | VARCHAR2 | (25) | ||
RCT_TERRITORY_SEGMENT12 | VARCHAR2 | (25) | ||
RCT_TERRITORY_SEGMENT13 | VARCHAR2 | (25) | ||
RCT_TERRITORY_SEGMENT14 | VARCHAR2 | (25) | ||
RCT_TERRITORY_SEGMENT15 | VARCHAR2 | (25) | ||
RCT_TERRITORY_SEGMENT16 | VARCHAR2 | (25) | ||
RCT_TERRITORY_SEGMENT17 | VARCHAR2 | (25) | ||
RCT_TERRITORY_SEGMENT18 | VARCHAR2 | (25) | ||
RCT_TERRITORY_SEGMENT19 | VARCHAR2 | (25) | ||
RCT_TERRITORY_SEGMENT2 | VARCHAR2 | (25) | ||
RCT_TERRITORY_SEGMENT20 | VARCHAR2 | (25) | ||
RCT_TERRITORY_SEGMENT3 | VARCHAR2 | (25) | ||
RCT_TERRITORY_SEGMENT4 | VARCHAR2 | (25) | ||
RCT_TERRITORY_SEGMENT5 | VARCHAR2 | (25) | ||
RCT_TERRITORY_SEGMENT6 | VARCHAR2 | (25) | ||
RCT_TERRITORY_SEGMENT7 | VARCHAR2 | (25) | ||
RCT_TERRITORY_SEGMENT8 | VARCHAR2 | (25) | ||
RCT_TERRITORY_SEGMENT9 | VARCHAR2 | (25) | ||
RCT_TERRITORY_ID | NUMBER | (15) | ||
RCT_SITE_CUST_CAT_CODE | VARCHAR2 | (30) | ||
RCT_SITE_GLOBAL_ATTR1 | VARCHAR2 | (150) | ||
RCT_SITE_GLOBAL_ATTR2 | VARCHAR2 | (150) | ||
RCT_SITE_GLOBAL_ATTR3 | VARCHAR2 | (150) | ||
RCT_SITE_GLOBAL_ATTR4 | VARCHAR2 | (150) | ||
RCT_SITE_GLOBAL_ATTR5 | VARCHAR2 | (150) | ||
RCT_SITE_GLOBAL_ATTR6 | VARCHAR2 | (150) | ||
RCT_SITE_GLOBAL_ATTR7 | VARCHAR2 | (150) | ||
RCT_SITE_GLOBAL_ATTR8 | VARCHAR2 | (150) | ||
RCT_SITE_GLOBAL_ATTR9 | VARCHAR2 | (150) | ||
RCT_SITE_GLOBAL_ATTR_CAT | VARCHAR2 | (30) | ||
RCT_SITE_PARTY_SITE_ID | NUMBER | (15) | Yes | |
EVENT_ID | NUMBER | (15) | ||
LEDGER_ID | NUMBER | (15) | ||
RCT_BILL_USES_CLEARING_CCID | NUMBER | (15) | ||
RCT_BILL_USES_FREIGHT_CCID | NUMBER | (15) | ||
RCT_BILL_USES_REC_CCID | NUMBER | (15) | ||
RCT_BILL_USES_REV_CCID | NUMBER | (15) | ||
RCT_BILL_USES_TAX_CCID | NUMBER | (15) | ||
RCT_BILL_USES_UNBILLED_CCID | NUMBER | (15) | ||
RCT_BILL_USES_UNEARNED_CCID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT RCT_SITE_CUST_ACCT_SITE_ID
, RCT_SITE_TRNSL_CUST_NAME
, RCT_SITE_GSA_INDICATOR
, RCT_SITE_LOCATION
, RCT_SITE_SITE_USE_CODE
, RCT_SITE_SITE_USE_ID
, RCT_SITE_TAX_REFERENCE
, RCT_TERRITORY_DESCRIPTION
, RCT_TERRITORY_NAME
, RCT_TERRITORY_SEGMENT1
, RCT_TERRITORY_SEGMENT10
, RCT_TERRITORY_SEGMENT11
, RCT_TERRITORY_SEGMENT12
, RCT_TERRITORY_SEGMENT13
, RCT_TERRITORY_SEGMENT14
, RCT_TERRITORY_SEGMENT15
, RCT_TERRITORY_SEGMENT16
, RCT_TERRITORY_SEGMENT17
, RCT_TERRITORY_SEGMENT18
, RCT_TERRITORY_SEGMENT19
, RCT_TERRITORY_SEGMENT2
, RCT_TERRITORY_SEGMENT20
, RCT_TERRITORY_SEGMENT3
, RCT_TERRITORY_SEGMENT4
, RCT_TERRITORY_SEGMENT5
, RCT_TERRITORY_SEGMENT6
, RCT_TERRITORY_SEGMENT7
, RCT_TERRITORY_SEGMENT8
, RCT_TERRITORY_SEGMENT9
, RCT_TERRITORY_ID
, RCT_SITE_CUST_CAT_CODE
, RCT_SITE_GLOBAL_ATTR1
, RCT_SITE_GLOBAL_ATTR2
, RCT_SITE_GLOBAL_ATTR3
, RCT_SITE_GLOBAL_ATTR4
, RCT_SITE_GLOBAL_ATTR5
, RCT_SITE_GLOBAL_ATTR6
, RCT_SITE_GLOBAL_ATTR7
, RCT_SITE_GLOBAL_ATTR8
, RCT_SITE_GLOBAL_ATTR9
, RCT_SITE_GLOBAL_ATTR_CAT
, RCT_SITE_PARTY_SITE_ID
, EVENT_ID
, LEDGER_ID
, RCT_BILL_USES_CLEARING_CCID
, RCT_BILL_USES_FREIGHT_CCID
, RCT_BILL_USES_REC_CCID
, RCT_BILL_USES_REV_CCID
, RCT_BILL_USES_TAX_CCID
, RCT_BILL_USES_UNBILLED_CCID
, RCT_BILL_USES_UNEARNED_CCID
FROM APPS.AR_RCT_SITE_USES_H_V;
|
|
|