[Home] [Help] [Dependency Information]
Object Name: | FTE_FPA_BOLS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View to catch bol related information
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ENTITY_ID | NUMBER | Entity Id ( FK Reference from WSH_DOCUMENT_INSTANCES) | ||
TRIP_ID | NUMBER | Trip id | ||
BILL_OF_LADING_NUMBER | VARCHAR2 | (50) | Bill of lading number | |
BILL_OF_LADING_DATE | DATE | Bill of lading date | ||
INITIAL_PICKUP_DATE | DATE | Initial pickup date | ||
ULTIMATE_DROPOFF_DATE | DATE | Ultimate dropoff date | ||
GROSS_WEIGHT | NUMBER | Gross weight | ||
WEIGHT_UOM_CODE | VARCHAR2 | (3) | Weight uom code | |
VOLUME | NUMBER | Volume | ||
VOLUME_UOM_CODE | VARCHAR2 | (3) | Volume uom code | |
SHIPPER_NAME | VARCHAR2 | (240) | Shipper name | |
SHIPPER_ADDRESS1 | VARCHAR2 | (240) | Shipper address 1 | |
SHIPPER_ADDRESS2 | VARCHAR2 | (240) | Shipper address 2 | |
SHIPPER_ADDRESS3 | VARCHAR2 | (240) | Shipper address 3 | |
SHIPPER_CITY | VARCHAR2 | (30) | Shipper city | |
SHIPPER_PHONE_NUMBER | VARCHAR2 | (60) | Shipper phone number | |
SHIPPER_FAX | VARCHAR2 | (60) | Shipper fax | |
SHIPPER_POSTAL_CODE | VARCHAR2 | (30) | Shipper postal code | |
SHIPPER_COUNTRY | VARCHAR2 | (60) | Shipper country | |
CUSTOMER_NAME | VARCHAR2 | (360) | Customer name | |
CUSTOMER_LAST_NAME | VARCHAR2 | (150) | Customer last name | |
PARTY_ID | NUMBER | Party id | ||
CUSTOMER_ADDRESS1 | VARCHAR2 | (240) | Customer address 1 | |
CUSTOMER_ADDRESS2 | VARCHAR2 | (240) | Customer address 2 | |
CUSTOMER_ADDRESS3 | VARCHAR2 | (240) | Customer address 3 | |
CUSTOMER_CITY | VARCHAR2 | (120) | Customer city | |
CUSTOMER_STATE | VARCHAR2 | (120) | Customer state | |
CUSTOMER_POSTAL_CODE | VARCHAR2 | (60) | Customer postal code | |
CUSTOMER_COUNTRY | VARCHAR2 | (120) | Customer country | |
SHIPPER_STATE | VARCHAR2 | (120) | Shipper State |
Cut, paste (and edit) the following text to query this object:
SELECT ENTITY_ID
, TRIP_ID
, BILL_OF_LADING_NUMBER
, BILL_OF_LADING_DATE
, INITIAL_PICKUP_DATE
, ULTIMATE_DROPOFF_DATE
, GROSS_WEIGHT
, WEIGHT_UOM_CODE
, VOLUME
, VOLUME_UOM_CODE
, SHIPPER_NAME
, SHIPPER_ADDRESS1
, SHIPPER_ADDRESS2
, SHIPPER_ADDRESS3
, SHIPPER_CITY
, SHIPPER_PHONE_NUMBER
, SHIPPER_FAX
, SHIPPER_POSTAL_CODE
, SHIPPER_COUNTRY
, CUSTOMER_NAME
, CUSTOMER_LAST_NAME
, PARTY_ID
, CUSTOMER_ADDRESS1
, CUSTOMER_ADDRESS2
, CUSTOMER_ADDRESS3
, CUSTOMER_CITY
, CUSTOMER_STATE
, CUSTOMER_POSTAL_CODE
, CUSTOMER_COUNTRY
, SHIPPER_STATE
FROM APPS.FTE_FPA_BOLS_V;
APPS.FTE_FPA_BOLS_V is not referenced by any database object
|
|
|