VIEW: APPS.MTL_MOVEMENT_PARAMETERS_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)