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

VIEW: GMF.GL_ACCT_HRC#

Object Details
Object Name: GL_ACCT_HRC#
Object Type: VIEW
Owner: GMF
Subobject Name:
Status: VALID

[View Source]

Columns
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)
Query Text

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#;

Dependencies

[top of page]

GMF.GL_ACCT_HRC# references the following:

SchemaGMF
TableGL_ACCT_HRC
GMF.GL_ACCT_HRC# is referenced by following:

SchemaAPPS
SynonymGL_ACCT_HRC