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

Object Details

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

[View Source]

Columns

Name	Datatype	Length
ROW_ID	ROWID	(10)
CONTEXT_VALUE	VARCHAR2	(30)
FISCAL_CLASSIFICATION_CODE	VARCHAR2	(240)
TRANSACTION_CONDITION_CLASS	VARCHAR2	(240)
DEF_FISCAL_CLASSIFICATION_CODE	VARCHAR2	(240)
DEF_TRX_CONDITION_CLASS	VARCHAR2	(240)
OPERATION_FISCAL_CODE	VARCHAR2	(240)
FREIGHT_ACCESSORY_EXPENSE	NUMBER
INSURANCE_ACCESSORY_EXPENSE	NUMBER
OTHER_ACCESORY_EXPENSE	NUMBER
ITEM_ORIGIN	VARCHAR2	(240)
FEDERAL_TRIBUTARY_SITUATION	VARCHAR2	(240)
STATE_TRIBUTARY_SITUATION	VARCHAR2	(240)
DEF_ITEM_ORIGIN	VARCHAR2	(240)
DEF_FED_TRIBUTARY_SITUATION	VARCHAR2	(240)
DEF_STA_TRIBUTARY_SITUATION	VARCHAR2	(240)
DEF_OPERATION_FISCAL_CODE	VARCHAR2	(240)
SERVICE_EXEC_DATE	DATE
CONCATENATED_SEGMENTS	VARCHAR2	(3886)

Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      FISCAL_CLASSIFICATION_CODE
,      TRANSACTION_CONDITION_CLASS
,      DEF_FISCAL_CLASSIFICATION_CODE
,      DEF_TRX_CONDITION_CLASS
,      OPERATION_FISCAL_CODE
,      FREIGHT_ACCESSORY_EXPENSE
,      INSURANCE_ACCESSORY_EXPENSE
,      OTHER_ACCESORY_EXPENSE
,      ITEM_ORIGIN
,      FEDERAL_TRIBUTARY_SITUATION
,      STATE_TRIBUTARY_SITUATION
,      DEF_ITEM_ORIGIN
,      DEF_FED_TRIBUTARY_SITUATION
,      DEF_STA_TRIBUTARY_SITUATION
,      DEF_OPERATION_FISCAL_CODE
,      SERVICE_EXEC_DATE
,      CONCATENATED_SEGMENTS
FROM APPS.OE_ORDER_LINES_ALL5_DFV;

Dependencies

[top of page]

APPS.OE_ORDER_LINES_ALL5_DFV references the following:

APPS: FND_NUMBER - show dependent code; OE_ORDER_LINES_ALL

APPS.OE_ORDER_LINES_ALL5_DFV is not referenced by any database object