View: INVFV_INTERORG_LEAD_TIMES

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

View Text

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

Columns