[Home] [Help]
[Dependency Information]
| Object Name: | FTE_SS_RATE_SORT_REC |
|---|---|
| Object Type: | TYPE |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
| Type Code: | OBJECT |
|---|---|
| Predefined: | NO |
| Incomplete: | NO |
| Name | Datatype | Length | Prcn |
|---|---|---|---|
| RANK_ID | NUMBER |
|
|
| RANK_SEQUENCE | NUMBER |
|
|
| LANE_ID | NUMBER |
|
|
| SCHEDULE_ID | NUMBER |
|
|
| CARRIER_ID | NUMBER |
|
|
| MODE_OF_TRANSPORT | VARCHAR2 | (30) | |
| SERVICE_LEVEL | VARCHAR2 | (30) | |
| VEHICLE_ITEM_ID | NUMBER |
|
|
| VEHICLE_ORG_ID | NUMBER |
|
|
| SORT | VARCHAR2 | (2) | |
| SOURCE | VARCHAR2 | (30) | |
| RATE | NUMBER |
|
|
| CURRENCY | VARCHAR2 | (15) | |
| EST_TRANSIT_TIME | NUMBER |
|
|
| EST_TRANSIT_TIME_UOM | VARCHAR2 | (3) | |
| SCHEDULE_FROM | DATE |
|
|
| SCHEDULE_TO | DATE |
|
|
| IS_CURRENT | VARCHAR2 | (1) | |
| VERSION | NUMBER |
|
|
| SINGLE_CURR_RATE | NUMBER |
|
|
| CONSIGNEE_CARRIER_AC_NO | VARCHAR2 | (240) | |
| FREIGHT_TERMS_CODE | VARCHAR2 | (30) |
SYS
STANDARD
- show dependent code
APPS
FTE_CARRIER_RANK_LIST_PVT
- show dependent code
FTE_MLS_TEST_NT
- show dependent code
FTE_SS_INTERFACE
- show dependent code
FTE_SS_RATE_SORT_TAB_TYPE
|
|
|
|