eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: FTE.FTE_INVOICE_HEADERS#

Object Details

Object Name:	FTE_INVOICE_HEADERS#
Object Type:	VIEW
Owner:	FTE
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
BILL_OF_LADING_ESTIMATE	NUMBER
INVOICE_HEADER_ID	NUMBER		Yes
BILL_NUMBER	VARCHAR2	(30)	Yes
BILL_STATUS	VARCHAR2	(30)	Yes
BILL_DATE	DATE		Yes
BILL_TYPE	VARCHAR2	(30)
BILL_REF	VARCHAR2	(30)
BOL	VARCHAR2	(30)
PICKUP_DATE	DATE
PICKUP_LOCATION_ID	NUMBER
PICKUP_LOC_ADDRLINE	VARCHAR2	(1000)
PICKUP_LOC_CITY	VARCHAR2	(120)
PICKUP_LOC_STATE	VARCHAR2	(120)
PICKUP_LOC_COUNTRY	VARCHAR2	(120)
PICKUP_LOC_POSTALCODE	VARCHAR2	(60)
DROPOFF_DATE	DATE
DROPOFF_LOCATION_ID	NUMBER
DROPOFF_LOC_ADDRLINE	VARCHAR2	(1000)
DROPOFF_LOC_CITY	VARCHAR2	(120)
DROPOFF_LOC_STATE	VARCHAR2	(120)
DROPOFF_LOC_COUNTRY	VARCHAR2	(120)
DROPOFF_LOC_POSTALCODE	VARCHAR2	(60)
SCAC_CODE	VARCHAR2	(4)
CARRIER_ID	NUMBER
SUPPLIER_ID	NUMBER
SUPPLIER_SITE_ID	NUMBER
MODE_OF_TRANSPORT	VARCHAR2	(30)
VEHICLE_TYPE	VARCHAR2	(30)
LOADED_DISTANCE_UOM	VARCHAR2	(30)
LOADED_DISTANCE	NUMBER
UNLOADED_DISTANCE_UOM	VARCHAR2	(30)
UNLOADED_DISTANCE	NUMBER
BILLED_TIME_UOM	VARCHAR2	(30)
BILLED_TIME	NUMBER
TOTAL_AMOUNT	NUMBER
APPROVED_AMOUNT	NUMBER
CURRENCY_CODE	VARCHAR2	(15)
REMARKS	VARCHAR2	(1000)
EDIT_AUDIT_DETAIL	VARCHAR2	(1)
EDIT_BILL	VARCHAR2	(1)
SOURCE	VARCHAR2	(30)
CREATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER
ORG_ID	NUMBER
DISTRIBUTION_ACCOUNT_ID	NUMBER
REQUEST_ID	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
CARRIER_NAME	VARCHAR2	(240)
DROPOFF_LOCATION	VARCHAR2	(240)
PICKUP_LOCATION	VARCHAR2	(240)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BILL_OF_LADING_ESTIMATE
,      INVOICE_HEADER_ID
,      BILL_NUMBER
,      BILL_STATUS
,      BILL_DATE
,      BILL_TYPE
,      BILL_REF
,      BOL
,      PICKUP_DATE
,      PICKUP_LOCATION_ID
,      PICKUP_LOC_ADDRLINE
,      PICKUP_LOC_CITY
,      PICKUP_LOC_STATE
,      PICKUP_LOC_COUNTRY
,      PICKUP_LOC_POSTALCODE
,      DROPOFF_DATE
,      DROPOFF_LOCATION_ID
,      DROPOFF_LOC_ADDRLINE
,      DROPOFF_LOC_CITY
,      DROPOFF_LOC_STATE
,      DROPOFF_LOC_COUNTRY
,      DROPOFF_LOC_POSTALCODE
,      SCAC_CODE
,      CARRIER_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      MODE_OF_TRANSPORT
,      VEHICLE_TYPE
,      LOADED_DISTANCE_UOM
,      LOADED_DISTANCE
,      UNLOADED_DISTANCE_UOM
,      UNLOADED_DISTANCE
,      BILLED_TIME_UOM
,      BILLED_TIME
,      TOTAL_AMOUNT
,      APPROVED_AMOUNT
,      CURRENCY_CODE
,      REMARKS
,      EDIT_AUDIT_DETAIL
,      EDIT_BILL
,      SOURCE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      DISTRIBUTION_ACCOUNT_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CARRIER_NAME
,      DROPOFF_LOCATION
,      PICKUP_LOCATION
FROM FTE.FTE_INVOICE_HEADERS#;

Dependencies

[top of page]

FTE.FTE_INVOICE_HEADERS# references the following:

FTE: FTE_INVOICE_HEADERS

FTE.FTE_INVOICE_HEADERS# is referenced by following:

APPS: FTE_INVOICE_HEADERS