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]

VIEW: APPS.FIIBV_AR_ARTT_TYPE_LCV

Object Details

Object Name:	FIIBV_AR_ARTT_TYPE_LCV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FII.FIIBV_AR_ARTT_TYPE_LCV
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

FIIBV_AR_ARTT_TYPE_LCV is the base view for AR Transaction type level of AR Transaction Type dimension

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TRX_TYPE_PK	VARCHAR2	(122)		The unique identifier for transaction type
TRX_CODE_FK	VARCHAR2	(20)		Foreign key to transaction quickcode
TRX_TYPE_DP	VARCHAR2	(20)		Unique transaction type name
NAME	VARCHAR2	(20)		Name of the transaction type
TRANSACTION_TYPE	VARCHAR2	(20)		Brief description of transaction type
ALLOW_FRT_FLAG	VARCHAR2	(1)	Yes	Yes/No flag indicates whether freight is allowed on transaction
ALLOW_OVAPP_FLAG	VARCHAR2	(1)	Yes	Yes / No flag indicates whether applications can exceed the transaction amount
CREATION_SIGN	VARCHAR2	(30)	Yes	Determines allowable signs for transactions
DEFAULT_STATUS	VARCHAR2	(30)	Yes	Status to default for transactions of this type
DESCRIPTION	VARCHAR2	(80)		Detailed description of transaction type
STATUS	VARCHAR2	(30)		Transaction type status flag
TAX_CALC_FLAG	VARCHAR2	(1)	Yes	Yes / No flag indicates whether tax is allowed on transactions
CM_TYPE_ID	NUMBER	(15)		Transaction type identifier of subsequent credit memos
DEFAULT_TERM	NUMBER	(15)		Term to default for transactions of this type
END_DATE	DATE			Transaction type end date
GL_ID_CLEARING	NUMBER	(15)		Clearing account identifier
GL_ID_FREIGHT	NUMBER	(15)		Freight account identifier
GL_ID_REC	NUMBER	(15)		Receivables account identifier
GL_ID_REV	NUMBER	(15)		Revenue account identifier
GL_ID_TAX	NUMBER	(15)		Tax account identifier
GL_ID_UNBILLED	NUMBER	(15)		Unbilled account identifier
GL_ID_UNEARNED	NUMBER	(15)		Unearned account identifier
ORG_ID	NUMBER	(15)		Organization identifier
RULE_SET_ID	NUMBER			Application rule set identifer for this transaction type
SET_OF_BOOKS_ID	NUMBER	(15)		Set of books identifier
START_DATE	DATE		Yes	Transaction type start date
SUB_TRX_TYPE_ID	NUMBER	(15)		Transaction type for transactions related to a commitment of this type
INSTANCE	VARCHAR2	(40)		Instance identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
_DF:RAT:_EDW	CHAR	(28)		This column is for internal use only
_DF:JGT:_EDW	CHAR	(31)		This column is for internal use only

Query Text

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


SELECT TRX_TYPE_PK
,      TRX_CODE_FK
,      TRX_TYPE_DP
,      NAME
,      TRANSACTION_TYPE
,      ALLOW_FRT_FLAG
,      ALLOW_OVAPP_FLAG
,      CREATION_SIGN
,      DEFAULT_STATUS
,      DESCRIPTION
,      STATUS
,      TAX_CALC_FLAG
,      CM_TYPE_ID
,      DEFAULT_TERM
,      END_DATE
,      GL_ID_CLEARING
,      GL_ID_FREIGHT
,      GL_ID_REC
,      GL_ID_REV
,      GL_ID_TAX
,      GL_ID_UNBILLED
,      GL_ID_UNEARNED
,      ORG_ID
,      RULE_SET_ID
,      SET_OF_BOOKS_ID
,      START_DATE
,      SUB_TRX_TYPE_ID
,      INSTANCE
,      LAST_UPDATE_DATE
,      _DF:RAT:_EDW
,      _DF:JGT:_EDW
FROM APPS.FIIBV_AR_ARTT_TYPE_LCV;

Dependencies

[top of page]

APPS.FIIBV_AR_ARTT_TYPE_LCV references the following:

APPS: EDW_INSTANCE - show dependent code; RA_CUST_TRX_TYPES_ALL

APPS.FIIBV_AR_ARTT_TYPE_LCV is referenced by following:

APPS: FII_AR_ARTT_TYPE_LCV