View: MTL_MOVEMENT_PARAMETERS_V

Product:	INV - Inventory
Description:	10SC ONLY
Implementation/DBA Data:	APPS.MTL_MOVEMENT_PARAMETERS_V

View Text

SELECT M.ROWID
, M.ENTITY_ORG_ID
, ENT.NAME
, M.ENTITY_BRANCH_REFERENCE
, M.PERIOD_SET_NAME
, M.CATEGORY_SET_ID
, CATT.CATEGORY_SET_NAME
, M.WEIGHT_UOM_CODE
, M.TAX_OFFICE_NAME
, M.TAX_OFFICE_CODE
, M.TAX_OFFICE_LOCATION_ID
, LOT.LOCATION_CODE
, M.CONVERSION_OPTION
, M.CONVERSION_TYPE
, TYP.USER_CONVERSION_TYPE
, M.LAST_DISPATCH_PERIOD
, M.LAST_DISPATCH_ID
, M.LAST_ARRIVAL_PERIOD
, M.LAST_ARRIVAL_ID
, M.LAST_DISPATCH_ADJ_PERIOD
, M.LAST_DISPATCH_ADJ_ID
, M.LAST_ARRIVAL_ADJ_PERIOD
, M.LAST_ARRIVAL_ADJ_ID
, M.LAST_UPDATE_DATE
, M.LAST_UPDATED_BY
, M.CREATION_DATE
, M.CREATED_BY
, M.LAST_UPDATE_LOGIN
, M.ATTRIBUTE_CATEGORY
, M.ATTRIBUTE1
, M.ATTRIBUTE2
, M.ATTRIBUTE3
, M.ATTRIBUTE4
, M.ATTRIBUTE5
, M.ATTRIBUTE6
, M.ATTRIBUTE7
, M.ATTRIBUTE8
, M.ATTRIBUTE9
, M.ATTRIBUTE10
, M.ATTRIBUTE11
, M.ATTRIBUTE12
, M.ATTRIBUTE13
, M.ATTRIBUTE14
, M.ATTRIBUTE15
, M.ATTRIBUTE16
, M.ATTRIBUTE17
, M.ATTRIBUTE18
, M.ATTRIBUTE19
, M.ATTRIBUTE20
, M.ATTRIBUTE21
, M.ATTRIBUTE22
, M.ATTRIBUTE23
, M.ATTRIBUTE24
, M.ATTRIBUTE25
, M.ATTRIBUTE26
, M.ATTRIBUTE27
, M.ATTRIBUTE28
, M.ATTRIBUTE29
, M.ATTRIBUTE30
FROM MTL_MOVEMENT_PARAMETERS M
, HR_LEGAL_ENTITIES ENT
, HR_LOCATIONS_NO_JOIN LOC
, HR_LOCATIONS_ALL_TL LOT
, MTL_CATEGORY_SETS_TL CATT
, MTL_CATEGORY_SETS_B CATB
, GL_DAILY_CONVERSION_TYPES TYP
WHERE M.ENTITY_ORG_ID = ENT.ORGANIZATION_ID
AND M.TAX_OFFICE_LOCATION_ID = LOC.LOCATION_ID (+)
AND LOC.LOCATION_ID = LOT.LOCATION_ID(+)
AND DECODE(LOT.LOCATION_ID
, NULL
, '1'
, LOT.LANGUAGE) = DECODE(LOT.LOCATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND M.CATEGORY_SET_ID = CATB.CATEGORY_SET_ID (+)
AND CATB.CATEGORY_SET_ID = CATT.CATEGORY_SET_ID (+)
AND DECODE(CATT.CATEGORY_SET_ID
, NULL
, '1'
, CATT.LANGUAGE) = DECODE(CATT.CATEGORY_SET_ID
, NULL
, '1'
, USERENV('LANG'))
AND M.CONVERSION_TYPE = TYP.CONVERSION_TYPE (+)

Columns