VIEW: APPS.INVFV_MOVEMENT_PARAMETERS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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