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.MTL_ITEM_TEMPLATES1_DFV

Object Details

Object Name:	MTL_ITEM_TEMPLATES1_DFV
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
ROW_ID	ROWID	(10)
CONTEXT_VALUE	VARCHAR2	(150)
ITEM_INV_APPLICATION	VARCHAR2	(150)
TRANSACTION_NATURE	VARCHAR2	(150)
ITEM_ORIGIN	VARCHAR2	(150)
ITEM_FISCAL_TYPE	VARCHAR2	(150)
FEDERAL_TRIBUTARY_SITUATION_	VARCHAR2	(150)
STATE_TRIBUTARY_SITUATION	VARCHAR2	(150)
IPI_TAX_SWITCHER	VARCHAR2	(150)
ALPHANUMERIC_BARCODE	VARCHAR2	(150)
SERVICE_CODE	VARCHAR2	(150)
ANP_FUEL_CODE	VARCHAR2	(150)
GLOBAL_TRADE_ITEM_NUMBER	VARCHAR2	(150)
EX_CODE	VARCHAR2	(150)
INCOME_NATURE_IND	VARCHAR2	(150)
CONCATENATED_SEGMENTS	VARCHAR2	(2113)

Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      ITEM_INV_APPLICATION
,      TRANSACTION_NATURE
,      ITEM_ORIGIN
,      ITEM_FISCAL_TYPE
,      FEDERAL_TRIBUTARY_SITUATION_
,      STATE_TRIBUTARY_SITUATION
,      IPI_TAX_SWITCHER
,      ALPHANUMERIC_BARCODE
,      SERVICE_CODE
,      ANP_FUEL_CODE
,      GLOBAL_TRADE_ITEM_NUMBER
,      EX_CODE
,      INCOME_NATURE_IND
,      CONCATENATED_SEGMENTS
FROM APPS.MTL_ITEM_TEMPLATES1_DFV;

Dependencies

[top of page]

APPS.MTL_ITEM_TEMPLATES1_DFV references the following:

APPS: MTL_ITEM_TEMPLATES_B

APPS.MTL_ITEM_TEMPLATES1_DFV is not referenced by any database object