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_SYSTEM_ITEMS_B4_DFV

Object Details

Object Name:	MTL_SYSTEM_ITEMS_B4_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_CONDITION_CODE	VARCHAR2	(150)
FOUR_DIGIT_CODE	VARCHAR2	(150)
TRANSACTION_CONDITION_CLASS	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)
INFLATION_ADJUSTMENT_ACCOUNT	VARCHAR2	(150)
MONETARY_CORRECTION_ACCOUNT	VARCHAR2	(150)
SALES_COST_ACCOUNT	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_CONDITION_CODE
,      FOUR_DIGIT_CODE
,      TRANSACTION_CONDITION_CLASS
,      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
,      INFLATION_ADJUSTMENT_ACCOUNT
,      MONETARY_CORRECTION_ACCOUNT
,      SALES_COST_ACCOUNT
,      CONCATENATED_SEGMENTS
FROM APPS.MTL_SYSTEM_ITEMS_B4_DFV;

Dependencies

[top of page]

APPS.MTL_SYSTEM_ITEMS_B4_DFV references the following:

APPS: MTL_SYSTEM_ITEMS_B

APPS.MTL_SYSTEM_ITEMS_B4_DFV is not referenced by any database object