View: INVFV_MOVEMENT_PARAMETERS

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.INVFV_MOVEMENT_PARAMETERS

View Text

SELECT MMP.ENTITY_ORG_ID
, HLE.NAME
, MMP.PERIOD_SET_NAME
, MMP.WEIGHT_UOM_CODE
, MMP.CONVERSION_TYPE
, '_LA:MMP.CONVERSION_OPTION:FND_LOOKUPS:MVT_CURR_CONV_OPTION:MEANING'
, /* LOOKUP */ MMP.CATEGORY_SET_ID
, MCS.CATEGORY_SET_NAME
, MMP.TAX_OFFICE_CODE
, MMP.TAX_OFFICE_NAME
, MMP.TAX_OFFICE_LOCATION_ID
, HL.LOCATION_CODE
, HL.DESCRIPTION
, MMP.CREATED_BY
, MMP.CREATION_DATE
, MMP.LAST_UPDATED_BY
, MMP.LAST_UPDATE_DATE
FROM HR_LOCATIONS HL
, HR_LEGAL_ENTITIES HLE
, MTL_CATEGORY_SETS MCS
, MTL_MOVEMENT_PARAMETERS MMP
WHERE HLE.ORGANIZATION_ID = MMP.ENTITY_ORG_ID
AND MCS.CATEGORY_SET_ID (+) = MMP.CATEGORY_SET_ID
AND HL.LOCATION_ID (+) = MMP.TAX_OFFICE_LOCATION_ID WITH READ ONLY

Columns