[Home] [Help] [Dependency Information]
Object Name: | GL_ACCT_HRC# |
---|---|
Object Type: | VIEW |
Owner: | GMF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCT_HRC_ID | NUMBER | (15) | Yes | |
CO_CODE | VARCHAR2 | (4) | ||
ACCT_TTL_TYPE | NUMBER | Yes | ||
ORGN_CODE_PRI | NUMBER | Yes | ||
WHSE_CODE_PRI | NUMBER | Yes | ||
ITEM_PRI | NUMBER | Yes | ||
VENDOR_PRI | NUMBER | Yes | ||
CUSTOMER_PRI | NUMBER | Yes | ||
REASON_CODE_PRI | NUMBER | Yes | ||
ICGL_CLASS_PRI | NUMBER | Yes | ||
VENDGL_CLASS_PRI | NUMBER | Yes | ||
CUSTGL_CLASS_PRI | NUMBER | Yes | ||
CURRENCY_CODE_PRI | NUMBER | Yes | ||
ROUTING_PRI | NUMBER | Yes | ||
CHARGE_PRI | NUMBER | Yes | ||
TAX_AUTH_PRI | NUMBER | Yes | ||
AQUI_COST_CODE_PRI | NUMBER | Yes | ||
RESOURCE_PRI | NUMBER | (5) | Yes | |
COST_CMPNTCLS_PRI | NUMBER | (5) | Yes | |
COST_ANALYSIS_PRI | NUMBER | (5) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
TRANS_CNT | NUMBER | |||
TEXT_CODE | NUMBER | (10) | ||
DELETE_MARK | NUMBER | Yes | ||
ORDER_TYPE_PRI | NUMBER | (5) | Yes | |
GL_BUSINESS_CLASS_PRI | NUMBER | (5) | Yes | |
GL_PRODUCT_LINE_PRI | NUMBER | (5) | Yes | |
LINE_TYPE_PRI | NUMBER | (5) | Yes | |
AR_TRX_TYPE_PRI | NUMBER | (5) |
Cut, paste (and edit) the following text to query this object:
SELECT ACCT_HRC_ID
, CO_CODE
, ACCT_TTL_TYPE
, ORGN_CODE_PRI
, WHSE_CODE_PRI
, ITEM_PRI
, VENDOR_PRI
, CUSTOMER_PRI
, REASON_CODE_PRI
, ICGL_CLASS_PRI
, VENDGL_CLASS_PRI
, CUSTGL_CLASS_PRI
, CURRENCY_CODE_PRI
, ROUTING_PRI
, CHARGE_PRI
, TAX_AUTH_PRI
, AQUI_COST_CODE_PRI
, RESOURCE_PRI
, COST_CMPNTCLS_PRI
, COST_ANALYSIS_PRI
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, TRANS_CNT
, TEXT_CODE
, DELETE_MARK
, ORDER_TYPE_PRI
, GL_BUSINESS_CLASS_PRI
, GL_PRODUCT_LINE_PRI
, LINE_TYPE_PRI
, AR_TRX_TYPE_PRI
FROM GMF.GL_ACCT_HRC#;
|
|
|