[Home] [Help]
[Dependency Information]
| Object Name: | FTE_DLV_ACTION_PARAM_REC |
|---|---|
| Object Type: | TYPE |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
| Type Code: | OBJECT |
|---|---|
| Predefined: | NO |
| Incomplete: | NO |
| Name | Datatype | Length | Prcn |
|---|---|---|---|
| PHASE | NUMBER |
|
|
| ACTION_CODE | VARCHAR2 | (30) | |
| TRIP_ID | NUMBER |
|
|
| TRIP_NAME | VARCHAR2 | (30) | |
| PICKUP_STOP_ID | NUMBER |
|
|
| PICKUP_LOC_ID | NUMBER |
|
|
| PICKUP_STOP_SEQ | NUMBER |
|
|
| PICKUP_LOC_CODE | VARCHAR2 | (80) | |
| PICKUP_ARR_DATE | DATE |
|
|
| PICKUP_DEP_DATE | DATE |
|
|
| PICKUP_STOP_STATUS | VARCHAR2 | (2) | |
| DROPOFF_STOP_ID | NUMBER |
|
|
| DROPOFF_LOC_ID | NUMBER |
|
|
| DROPOFF_STOP_SEQ | NUMBER |
|
|
| DROPOFF_LOC_CODE | VARCHAR2 | (80) | |
| DROPOFF_ARR_DATE | DATE |
|
|
| DROPOFF_DEP_DATE | DATE |
|
|
| DROPOFF_STOP_STATUS | VARCHAR2 | (2) | |
| ACTION_FLAG | VARCHAR2 | (1) | |
| INTRANSIT_FLAG | VARCHAR2 | (1) | |
| CLOSE_TRIP_FLAG | VARCHAR2 | (1) | |
| STAGE_DEL_FLAG | VARCHAR2 | (1) | |
| BILL_OF_LADING_FLAG | VARCHAR2 | (1) | |
| MC_BILL_OF_LADING_FLAG | VARCHAR2 | (1) | |
| OVERRIDE_FLAG | VARCHAR2 | (1) | |
| SHIP_METHOD_CODE | VARCHAR2 | (240) | |
| ACTUAL_DEP_DATE | DATE |
|
|
| REPORT_SET_ID | NUMBER |
|
|
| REPORT_SET_NAME | VARCHAR2 | (30) | |
| SEND_945_FLAG | VARCHAR2 | (1) | |
| ACTION_TYPE | VARCHAR2 | (1) | |
| DOCUMENT_TYPE | VARCHAR2 | (2) | |
| ORGANIZATION_ID | NUMBER |
|
|
| REASON_OF_TRANSPORT | VARCHAR2 | (30) | |
| DESCRIPTION | VARCHAR2 | (30) |
SYS
STANDARD
- show dependent code
APPS
FTE_MLS_WRAPPER
- show dependent code
FTE_MLS_WRAPPER
- show dependent code
|
|
|
|