DBA Data[Home] [Help]

VIEW: APPS.INVFV_INTERORG_LEAD_TIMES

Source

View Text - Preformatted

SELECT MSM.FROM_ORGANIZATION_ID , MP1.ORGANIZATION_CODE , HOU1.NAME , MSM.TO_ORGANIZATION_ID , MP2.ORGANIZATION_CODE , HOU2.NAME , MSM.SHIP_METHOD , FCL.MEANING , MSM.TIME_UOM_CODE , MSM.INTRANSIT_TIME ,'_LA:MSM.DEFAULT_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' /* LOOKUP */ , MSM.FROM_LOCATION_ID , HRL1.LOCATION_CODE , MSM.TO_LOCATION_ID , HRL2.LOCATION_CODE , MSM.CREATED_BY , MSM.CREATION_DATE , MSM.LAST_UPDATED_BY , MSM.LAST_UPDATE_DATE FROM HR_LOCATIONS HRL1, HR_LOCATIONS HRL2, MTL_PARAMETERS MP1, MTL_PARAMETERS MP2, HR_ALL_ORGANIZATION_UNITS HOU1, HR_ALL_ORGANIZATION_UNITS HOU2, FND_COMMON_LOOKUPS FCL, MTL_INTERORG_SHIP_METHODS MSM WHERE MSM.FROM_ORGANIZATION_ID IS NOT NULL AND MSM.TO_ORGANIZATION_ID IS NOT NULL AND MP1.ORGANIZATION_ID = MSM.FROM_ORGANIZATION_ID AND MP2.ORGANIZATION_ID = MSM.TO_ORGANIZATION_ID AND HOU1.ORGANIZATION_ID = MSM.FROM_ORGANIZATION_ID AND HOU2.ORGANIZATION_ID = MSM.TO_ORGANIZATION_ID AND FCL.APPLICATION_ID = 401 AND FCL.LOOKUP_TYPE = 'SHIP_METHOD' AND FCL.LOOKUP_CODE = MSM.SHIP_METHOD AND HRL1.LOCATION_ID (+) = MSM.FROM_LOCATION_ID AND HRL2.LOCATION_ID (+) = MSM.TO_LOCATION_ID AND '_SEC:MSM.FROM_ORGANIZATION_ID' IS NOT NULL AND '_SEC:MSM.TO_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY
View Text - HTML Formatted

SELECT MSM.FROM_ORGANIZATION_ID
, MP1.ORGANIZATION_CODE
, HOU1.NAME
, MSM.TO_ORGANIZATION_ID
, MP2.ORGANIZATION_CODE
, HOU2.NAME
, MSM.SHIP_METHOD
, FCL.MEANING
, MSM.TIME_UOM_CODE
, MSM.INTRANSIT_TIME
, '_LA:MSM.DEFAULT_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' /* LOOKUP */
, MSM.FROM_LOCATION_ID
, HRL1.LOCATION_CODE
, MSM.TO_LOCATION_ID
, HRL2.LOCATION_CODE
, MSM.CREATED_BY
, MSM.CREATION_DATE
, MSM.LAST_UPDATED_BY
, MSM.LAST_UPDATE_DATE
FROM HR_LOCATIONS HRL1
, HR_LOCATIONS HRL2
, MTL_PARAMETERS MP1
, MTL_PARAMETERS MP2
, HR_ALL_ORGANIZATION_UNITS HOU1
, HR_ALL_ORGANIZATION_UNITS HOU2
, FND_COMMON_LOOKUPS FCL
, MTL_INTERORG_SHIP_METHODS MSM
WHERE MSM.FROM_ORGANIZATION_ID IS NOT NULL
AND MSM.TO_ORGANIZATION_ID IS NOT NULL
AND MP1.ORGANIZATION_ID = MSM.FROM_ORGANIZATION_ID
AND MP2.ORGANIZATION_ID = MSM.TO_ORGANIZATION_ID
AND HOU1.ORGANIZATION_ID = MSM.FROM_ORGANIZATION_ID
AND HOU2.ORGANIZATION_ID = MSM.TO_ORGANIZATION_ID
AND FCL.APPLICATION_ID = 401
AND FCL.LOOKUP_TYPE = 'SHIP_METHOD'
AND FCL.LOOKUP_CODE = MSM.SHIP_METHOD
AND HRL1.LOCATION_ID (+) = MSM.FROM_LOCATION_ID
AND HRL2.LOCATION_ID (+) = MSM.TO_LOCATION_ID
AND '_SEC:MSM.FROM_ORGANIZATION_ID' IS NOT NULL
AND '_SEC:MSM.TO_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY