FND Design Data [Home] [Help]

View: INVBV_INTERORG_LEAD_TIMES

Product: INV - Inventory
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.INVBV_INTERORG_LEAD_TIMES
View Text

SELECT MSM.FROM_ORGANIZATION_ID
, MSM.TO_ORGANIZATION_ID
, MSM.SHIP_METHOD
, MSM.TIME_UOM_CODE
, MSM.INTRANSIT_TIME
, '_LA:MSM.DEFAULT_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' /* LOOKUP */
, MSM.FROM_LOCATION_ID
, MSM.TO_LOCATION_ID
, MSM.CREATED_BY
, MSM.CREATION_DATE
, MSM.LAST_UPDATED_BY
, MSM.LAST_UPDATE_DATE
FROM MTL_INTERORG_SHIP_METHODS MSM
WHERE MSM.FROM_ORGANIZATION_ID IS NOT NULL
AND MSM.TO_ORGANIZATION_ID IS NOT NULL
AND '_SEC:MSM.FROM_ORGANIZATION_ID' IS NOT NULL
AND '_SEC:MSM.TO_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns

Name
FROM_ORGANIZATION_ID
TO_ORGANIZATION_ID
SHIP_METHOD_CODE
TIME_UOM_CODE
INTRANSIT_TIME
"_LA:DEFAULT_FLAG"
FROM_LOCATION_ID
TO_LOCATION_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE