[Home] [Help]
[Dependency Information]
| Object Name: | FTE_LANE_REC |
|---|---|
| Object Type: | TYPE |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
| Type Code: | OBJECT |
|---|---|
| Predefined: | NO |
| Incomplete: | NO |
| 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) |
SYS
STANDARD
- show dependent code
APPS
FTE_FREIGHT_RATING_DLVY_GRP
- show dependent code
FTE_FREIGHT_RATING_PUB
- show dependent code
FTE_LANE_SEARCH
- show dependent code
FTE_LANE_TAB
FTE_TRIP_RATING_GRP
- show dependent code
|
|
|
|