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

TYPE: APPS.FTE_SEARCH_CRITERIA_REC

Object Details
Object Name: FTE_SEARCH_CRITERIA_REC
Object Type: TYPE
Owner: APPS
Subobject Name:
Status: VALID
Type Details
Type Code: OBJECT
Predefined: NO
Incomplete: NO
Attributes
Name Datatype Length Prcn
RELAX_FLAG VARCHAR2 (1)
ORIGIN_LOC_ID NUMBER

DESTINATION_LOC_ID NUMBER

ORIGIN_COUNTRY VARCHAR2 (30)
ORIGIN_STATE VARCHAR2 (30)
ORIGIN_CITY VARCHAR2 (30)
ORIGIN_ZIP VARCHAR2 (30)
DESTINATION_COUNTRY VARCHAR2 (30)
DESTINATION_STATE VARCHAR2 (30)
DESTINATION_CITY VARCHAR2 (30)
DESTINATION_ZIP VARCHAR2 (30)
MODE_OF_TRANSPORT VARCHAR2 (30)
LANE_NUMBER VARCHAR2 (30)
CARRIER_ID NUMBER

CARRIER_NAME VARCHAR2 (360)
COMMODITY_CATG_ID NUMBER

COMMODITY VARCHAR2 (240)
SERVICE_CODE VARCHAR2 (30)
SERVICE VARCHAR2 (80)
SCHEDULE_ONLY_FLAG VARCHAR2 (1)
DEP_DATE_FROM DATE

DEP_DATE_TO DATE

ARR_DATE_FROM DATE

ARR_DATE_TO DATE

LANE_IDS_STRING VARCHAR2 (2000)
DELIVERY_LEG_ID NUMBER

EXISTS_IN_DATABASE VARCHAR2 (1)
DELIVERY_ID NUMBER

SEQUENCE_NUMBER NUMBER

PICK_UP_STOP_ID NUMBER

DROP_OFF_STOP_ID NUMBER

PICKUPSTOP_LOCATION_ID NUMBER

DROPOFFSTOP_LOCATION_ID NUMBER

SHIP_TO_SITE_ID NUMBER

VEHICLE_ID NUMBER

EFFECTIVE_DATE DATE

EFFECTIVE_DATE_TYPE VARCHAR2 (10)
TARIFF_NAME VARCHAR2 (80)

Dependencies

[top of page]

APPS.FTE_SEARCH_CRITERIA_REC references the following:

SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
APPS.FTE_SEARCH_CRITERIA_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
PL/SQL PackageFTE_LANE_SEARCH - show dependent code
TYPEFTE_SEARCH_CRITERIA_TAB
Package BodyFTE_TRIP_RATING_GRP - show dependent code