DBA Data[Home] [Help] [Dependency Information]


TYPE: APPS.FTE_LANE_REC

Object Details
Object Name: FTE_LANE_REC
Object Type: TYPE
Owner: APPS
Subobject Name:
Status: VALID
Type Details
Type Code: OBJECT
Predefined: NO
Incomplete: NO
Attributes
Name Datatype Length Prcn
LANE_ID NUMBER

LANE_NUMBER VARCHAR2 (30)
ORIGIN_ID NUMBER

DESTINATION_ID NUMBER

CARRIER_ID NUMBER

MODE_OF_TRANSPORT_CODE VARCHAR2 (30)
COMM_FC_CLASS_CODE VARCHAR2 (30)
COMMODITY_CATG_ID NUMBER

SERVICE_CODE VARCHAR2 (30)
SCHEDULES_FLAG_CODE VARCHAR2 (1)
RATE_CHART_ID NUMBER

BASIS VARCHAR2 (30)
TRANSIT_TIME NUMBER

TRANSIT_TIME_UOM VARCHAR2 (10)
DISTANCE NUMBER

DISTANCE_UOM VARCHAR2 (3)
CARRIER_NAME VARCHAR2 (80)
MODE_OF_TRANSPORT VARCHAR2 (80)
COMMODITY VARCHAR2 (80)
SERVICE VARCHAR2 (80)
SCHEDULES_FLAG VARCHAR2 (10)
PORT_OF_LOADING VARCHAR2 (240)
PORT_OF_DISCHARGE VARCHAR2 (240)
RATE_CHART_NAME VARCHAR2 (240)
OWNER_ID NUMBER

SPECIAL_HANDLING VARCHAR2 (2000)
ADDL_INSTR VARCHAR2 (2000)
COMMODITY_FLAG VARCHAR2 (1)
SERVICE_FLAG VARCHAR2 (1)
RATE_CHART_VIEW_FLAG VARCHAR2 (1)
EFFECTIVE_DATE DATE

EXPIRY_DATE DATE

ORIGIN_REGION_TYPE NUMBER

DEST_REGION_TYPE NUMBER

TARIFF_NAME VARCHAR2 (80)
LANE_TYPE VARCHAR2 (80)

Dependencies

[top of page]

APPS.FTE_LANE_REC references the following:

SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
APPS.FTE_LANE_REC is referenced by following:

SchemaAPPS
Package BodyFTE_FREIGHT_RATING_DLVY_GRP - show dependent code
Package BodyFTE_FREIGHT_RATING_PUB - show dependent code
Package BodyFTE_LANE_SEARCH - show dependent code
TYPEFTE_LANE_TAB
Package BodyFTE_TRIP_RATING_GRP - show dependent code