[Home] [Help] [Dependency Information]

VIEW: APPS.INVFV_INTERORG_LEAD_TIMES

Object Details

Object Name:	INVFV_INTERORG_LEAD_TIMES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	INV.INVFV_INTERORG_LEAD_TIMES
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This shows the lead time for shipping from one organization to another for a shipping method.

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT FROM_ORGANIZATION_ID
,      FROM_ORGANIZATION_CODE
,      FROM_ORGANIZATION_NAME
,      TO_ORGANIZATION_ID
,      TO_ORGANIZATION_CODE
,      TO_ORGANIZATION_NAME
,      SHIP_METHOD_CODE
,      SHIP_METHOD
,      TIME_UOM_CODE
,      INTRANSIT_TIME
,      _LA:DEFAULT_FLAG
,      FROM_LOCATION_ID
,      FROM_LOCATION_CODE
,      TO_LOCATION_ID
,      TO_LOCATION_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.INVFV_INTERORG_LEAD_TIMES;

Dependencies

[top of page]

APPS

FND_COMMON_LOOKUPS

FND_GLOBAL - show dependent code

HR_ALL_ORGANIZATION_UNITS

HR_GENERAL - show dependent code

HR_LOCATIONS

MTL_INTERORG_SHIP_METHODS

MTL_PARAMETERS

APPS.INVFV_INTERORG_LEAD_TIMES is not referenced by any database object