eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: AR.HZ_CUST_SITE_USES_ALL

Object Details

Object Name:	HZ_CUST_SITE_USES_ALL
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.HZ_CUST_SITE_USES_ALL
Subobject Name:
Status:	VALID

The HZ_CUST_SITE_USES_ALL table stores business purposes
assigned to customer account sites, for example Bill-To, Ship-To, and
Statements. Each customer account site can have one or more purposes.
This table is a child of the HZ_CUST_ACCT_SITES_ALL table, with the foreign
key CUST_ACCT_SITE_ID. The HZ_CUST_SITE_USES_ALL table also stores operating
unit identifier, though the HZ_CUST_ACCT_SITES_ALL table itself stores the
operating unit for customer account sites.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: HZ_CUST_SITE_USES_ALL_PK

SITE_USE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
HZ_CUST_SITE_USES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SITE_USE_ID
HZ_CUST_SITE_USES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUST_ACCT_SITE_ID SITE_USE_CODE PRIMARY_FLAG
HZ_CUST_SITE_USES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID STATUS
HZ_CUST_SITE_USES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION
HZ_CUST_SITE_USES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TAX_REFERENCE ORG_ID
HZ_CUST_SITE_USES_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BILL_TO_SITE_USE_ID SITE_USE_CODE ORG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SITE_USE_ID	NUMBER	(15)	Yes	Site use identifier
CUST_ACCT_SITE_ID	NUMBER	(15)	Yes	Identifier for the customer account site. Foreign key to the HZ_CUST_ACCT_SITES_ALL table
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
SITE_USE_CODE	VARCHAR2	(30)	Yes	Business purpose assigned to customer site account, such as Bill-To, Market, and Statements.
PRIMARY_FLAG	VARCHAR2	(1)	Yes	Indicates if this site is the primary site for this customer account. Y for the primary customer account site. N for other customer account sites.
STATUS	VARCHAR2	(1)	Yes	Site use status flag, Lookup code for the CODE_STATUS column.
LOCATION	VARCHAR2	(40)	Yes	Site use identifier
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CONTACT_ID	NUMBER	(15)		No longer used
BILL_TO_SITE_USE_ID	NUMBER	(15)		Bill-To site use identifier
ORIG_SYSTEM_REFERENCE	VARCHAR2	(240)		Site use identifier from foreign or legacy system
SIC_CODE	VARCHAR2	(30)		Standard Industry Classification (SIC) code
PAYMENT_TERM_ID	NUMBER	(15)		Payment term identifier
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.
SHIP_PARTIAL	VARCHAR2	(1)		No longer used
SHIP_VIA	VARCHAR2	(30)		The name of the preferred ship method.
FOB_POINT	VARCHAR2	(30)		Free on board point. The FOB point indicates the point at which title of goods is transfered to the buyer.
ORDER_TYPE_ID	NUMBER	(15)		Order type identifier
PRICE_LIST_ID	NUMBER	(15)		Price list identifier
FREIGHT_TERM	VARCHAR2	(30)		Order Management lookup code for FREIGHT_TERMS
WAREHOUSE_ID	NUMBER	(15)		Warehouse identifier
TERRITORY_ID	NUMBER	(15)		Territory identifier
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
TAX_REFERENCE	VARCHAR2	(50)		Taxpayer identification number
SORT_PRIORITY	NUMBER	(5)		Sort priority
TAX_CODE	VARCHAR2	(50)		Tax code associated with this site
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE21	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE22	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE23	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE24	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE25	VARCHAR2	(150)		Descriptive Flexfield segment
LAST_ACCRUE_CHARGE_DATE	DATE			The last date that accrued finance charges were computed for this site.
SECOND_LAST_ACCRUE_CHARGE_DATE	DATE			The next-to-last date that accrued finance charges were computed for this site.
LAST_UNACCRUE_CHARGE_DATE	DATE			The last date that unaccrued finance charges were computed for this site.
SECOND_LAST_UNACCRUE_CHRG_DATE	DATE			The next-to-last date that unaccrued finance charges were computed for this site.
DEMAND_CLASS_CODE	VARCHAR2	(30)		Demand class (user-defined Lookup used by Oracle Manufacturing)
ORG_ID	NUMBER	(15)		Organization identifier
TAX_HEADER_LEVEL_FLAG	VARCHAR2	(1)		Used by Oracle Sales Compensation
TAX_ROUNDING_RULE	VARCHAR2	(30)		Tax rounding rule
WH_UPDATE_DATE	DATE			No longer used
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Reserved for country-specific functionality
PRIMARY_SALESREP_ID	NUMBER	(15)		Identifies a salesperson associated with a business site. Also used to default salesrep in the Transactions window. The hierarchy of defaulting would follow from Bill-To site to Ship-To site to Customer, if not a multi-org setup.
FINCHRG_RECEIVABLES_TRX_ID	NUMBER	(15)		Identifies receivables activity that are used for finance charges
DATES_NEGATIVE_TOLERANCE	NUMBER			Acceptable range of days prior to a specified date
DATES_POSITIVE_TOLERANCE	NUMBER			Acceptable range of days after a specified date
DATE_TYPE_PREFERENCE	VARCHAR2	(20)		Preference for ship or arrival dates
OVER_SHIPMENT_TOLERANCE	NUMBER			Percentage tolerance for over shipment
UNDER_SHIPMENT_TOLERANCE	NUMBER			Percentage tolerance for under shipment
ITEM_CROSS_REF_PREF	VARCHAR2	(30)		Lookup for item cross-reference preference for placing orders
OVER_RETURN_TOLERANCE	NUMBER			Percentage tolerance for over return
UNDER_RETURN_TOLERANCE	NUMBER			Percentage tolerance for under return
SHIP_SETS_INCLUDE_LINES_FLAG	VARCHAR2	(1)		Indicates if lines should automatically be included in ship sets. Y for lines included in ship sets. N for lines not included in ship sets.
ARRIVALSETS_INCLUDE_LINES_FLAG	VARCHAR2	(1)		Indicates if lines should automatically be included in ship sets. Y for lines included in ship sets. N for lines not included in ship sets.
SCHED_DATE_PUSH_FLAG	VARCHAR2	(1)		Indicates if the group schedule date should automatically be pushed. Y for pushing the schedule dates, N for not pushing the schedule date.
INVOICE_QUANTITY_RULE	VARCHAR2	(30)		Rule to indicate whether to invoice for ordered quantity or fulfilled quantity
PRICING_EVENT	VARCHAR2	(30)		No longer used
GL_ID_REC	NUMBER	(15)		Code combination ID for the Receivable Account
GL_ID_REV	NUMBER	(15)		Code combination ID for the Revenue Account
GL_ID_TAX	NUMBER	(15)		Code combination ID for the Tax Account
GL_ID_FREIGHT	NUMBER	(15)		Code combination ID for the Freight Account
GL_ID_CLEARING	NUMBER	(15)		Code combination ID for the Clearing Account
GL_ID_UNBILLED	NUMBER	(15)		Code combination ID for the Unbilled Account
GL_ID_UNEARNED	NUMBER	(15)		Code combination ID for the Unearned Account
GL_ID_UNPAID_REC	NUMBER	(15)		Unpaid Bills Receivable Account
GL_ID_REMITTANCE	NUMBER	(15)		Bill Receivable Remittance Account
GL_ID_FACTOR	NUMBER	(15)		Code combination ID for a bill-receivable factoring account. Used for Spanish requirements.
TAX_CLASSIFICATION	VARCHAR2	(30)		Classifies Bill-To site to tax group codes. Foreign key to the AR_LOOKUPS table (AR_TAX_CLASSIFICATION) used in AR_VAT_TAX (TAX_CLASSIFICATION) indexes
OBJECT_VERSION_NUMBER	NUMBER			This column is used for locking purposes
CREATED_BY_MODULE	VARCHAR2	(150)		TCA Who column
APPLICATION_ID	NUMBER			TCA Who column

Query Text

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


SELECT SITE_USE_ID
,      CUST_ACCT_SITE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      SITE_USE_CODE
,      PRIMARY_FLAG
,      STATUS
,      LOCATION
,      LAST_UPDATE_LOGIN
,      CONTACT_ID
,      BILL_TO_SITE_USE_ID
,      ORIG_SYSTEM_REFERENCE
,      SIC_CODE
,      PAYMENT_TERM_ID
,      GSA_INDICATOR
,      SHIP_PARTIAL
,      SHIP_VIA
,      FOB_POINT
,      ORDER_TYPE_ID
,      PRICE_LIST_ID
,      FREIGHT_TERM
,      WAREHOUSE_ID
,      TERRITORY_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      TAX_REFERENCE
,      SORT_PRIORITY
,      TAX_CODE
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      LAST_ACCRUE_CHARGE_DATE
,      SECOND_LAST_ACCRUE_CHARGE_DATE
,      LAST_UNACCRUE_CHARGE_DATE
,      SECOND_LAST_UNACCRUE_CHRG_DATE
,      DEMAND_CLASS_CODE
,      ORG_ID
,      TAX_HEADER_LEVEL_FLAG
,      TAX_ROUNDING_RULE
,      WH_UPDATE_DATE
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      PRIMARY_SALESREP_ID
,      FINCHRG_RECEIVABLES_TRX_ID
,      DATES_NEGATIVE_TOLERANCE
,      DATES_POSITIVE_TOLERANCE
,      DATE_TYPE_PREFERENCE
,      OVER_SHIPMENT_TOLERANCE
,      UNDER_SHIPMENT_TOLERANCE
,      ITEM_CROSS_REF_PREF
,      OVER_RETURN_TOLERANCE
,      UNDER_RETURN_TOLERANCE
,      SHIP_SETS_INCLUDE_LINES_FLAG
,      ARRIVALSETS_INCLUDE_LINES_FLAG
,      SCHED_DATE_PUSH_FLAG
,      INVOICE_QUANTITY_RULE
,      PRICING_EVENT
,      GL_ID_REC
,      GL_ID_REV
,      GL_ID_TAX
,      GL_ID_FREIGHT
,      GL_ID_CLEARING
,      GL_ID_UNBILLED
,      GL_ID_UNEARNED
,      GL_ID_UNPAID_REC
,      GL_ID_REMITTANCE
,      GL_ID_FACTOR
,      TAX_CLASSIFICATION
,      OBJECT_VERSION_NUMBER
,      CREATED_BY_MODULE
,      APPLICATION_ID
FROM AR.HZ_CUST_SITE_USES_ALL;

Dependencies

[top of page]

AR.HZ_CUST_SITE_USES_ALL does not reference any database object

AR.HZ_CUST_SITE_USES_ALL is referenced by following:

APPS: OE_ITEMS_MV
AR: HZ_CUST_SITE_USES_ALL#