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

Object Details

Object Name:	INVFV_MOVEMENT_PARAMETERS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	INV.INVFV_MOVEMENT_PARAMETERS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Movement Parameters are like calendar, currency exchange rate type, tax office, and contact information, required by legal entities for gathering.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ENTITY_ORGANIZATION_ID	NUMBER		Yes	Organization identifier
ENTITY_ORGANIZATION_NAME	VARCHAR2	(240)	Yes	Organization name
CALENDAR	VARCHAR2	(15)	Yes	Organization calendar
WEIGHT_UOM_CODE	VARCHAR2	(3)	Yes	Weight UOM code
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Currency conversion type
_LA:CURRENCY_CONV_OPTION	CHAR	(66)
CATEGORY_SET_ID	NUMBER			Category set identifier
CATEGORY_SET_NAME	VARCHAR2	(30)		Category set name
TAX_OFFICE_CODE	VARCHAR2	(50)		Tax office code
TAX_OFFICE_NAME	VARCHAR2	(240)		Tax office name
TAX_OFFICE_LOCATION_ID	NUMBER			Tax office location identifier
TAX_OFFICE_LOCATION_CODE	VARCHAR2	(60)		Tax office location code
TAX_OFFICE_LOCATION_DESC	VARCHAR2	(240)		Tax office location description
CREATED_BY	NUMBER		Yes	Standard WHO columns
CREATION_DATE	DATE		Yes	Standard WHO columns
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO columns
LAST_UPDATE_DATE	DATE		Yes	Standard WHO columns

Query Text

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


SELECT ENTITY_ORGANIZATION_ID
,      ENTITY_ORGANIZATION_NAME
,      CALENDAR
,      WEIGHT_UOM_CODE
,      CURRENCY_CONVERSION_TYPE
,      _LA:CURRENCY_CONV_OPTION
,      CATEGORY_SET_ID
,      CATEGORY_SET_NAME
,      TAX_OFFICE_CODE
,      TAX_OFFICE_NAME
,      TAX_OFFICE_LOCATION_ID
,      TAX_OFFICE_LOCATION_CODE
,      TAX_OFFICE_LOCATION_DESC
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.INVFV_MOVEMENT_PARAMETERS;

Dependencies

[top of page]

APPS.INVFV_MOVEMENT_PARAMETERS references the following:

APPS: HR_GENERAL - show dependent code; HR_LEGAL_ENTITIES; HR_LOCATIONS; HR_SECURITY - show dependent code; MTL_CATEGORY_SETS; MTL_MOVEMENT_PARAMETERS

APPS.INVFV_MOVEMENT_PARAMETERS is not referenced by any database object