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]

TABLE: OTA.OTA_FINANCE_LINES

Object Details

Object Name:	OTA_FINANCE_LINES
Object Type:	TABLE
Owner:	OTA
FND Design Data:	OTA.OTA_FINANCE_LINES
Subobject Name:
Status:	VALID

A finance line records each transaction with a supplier, customer or cost center as
a sum of money. It records charges to a customer or cost center for an enrollment or to deduct from the balance of a prepurchase agreement. You can also set up user-defined finance line types and record miscellaneous amounts to charge or receive.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: OTA_FINANCE_LINES_PK

FINANCE_LINE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
OTA_FINANCE_LINES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	FINANCE_LINE_ID
OTA_FINANCE_LINES_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FINANCE_HEADER_ID
OTA_FINANCE_LINES_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BOOKING_DEAL_ID
OTA_FINANCE_LINES_FK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BOOKING_ID
OTA_FINANCE_LINES_FK4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ALLOCATION_ID
OTA_FINANCE_LINES_FK5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_BOOKING_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
OTA_FINANCE_LINES	OTA_BOOKING_DEALS	OTA_FINANCE_LINES BOOKING_DEAL_ID
OTA_FINANCE_LINES	OTA_DELEGATE_BOOKINGS	OTA_FINANCE_LINES BOOKING_ID
OTA_FINANCE_LINES	OTA_FINANCE_HEADERS	OTA_FINANCE_LINES FINANCE_HEADER_ID
OTA_FINANCE_LINES	OTA_RESOURCE_ALLOCATIONS	OTA_FINANCE_LINES RESOURCE_ALLOCATION_ID
OTA_FINANCE_LINES	OTA_RESOURCE_BOOKINGS	OTA_FINANCE_LINES RESOURCE_BOOKING_ID

Columns

Name	Datatype	Length	Mandatory	Comments
FINANCE_LINE_ID	NUMBER	(9)	Yes	System generated reference number
FINANCE_HEADER_ID	NUMBER	(9)		Foreign key to OTA_FINANCE_HEADERS
CANCELLED_FLAG	VARCHAR2	(30)	Yes	The current state of this The current state of this valid
DATE_RAISED	DATE		Yes	The date this finance line was created
LINE_TYPE	VARCHAR2	(30)	Yes	The type of line: course payment / pre-purchase / delegate etc.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	The version number for change control
SEQUENCE_NUMBER	NUMBER	(9)	Yes	The order in which this line appears under the header
TRANSFER_STATUS	VARCHAR2	(30)	Yes	Status of transfer.
COMMENTS	VARCHAR2	(2000)		Free Text Comments
CURRENCY_CODE	VARCHAR2	(30)		The currency code of this finance line
MONEY_AMOUNT	NUMBER			The money amount which this line is charging or paying
STANDARD_AMOUNT	NUMBER			The money or unit value before a discount has been applied
TRANS_INFORMATION_CATEGORY	VARCHAR2	(30)		The control for the transfer descriptive flexfield
TRANS_INFORMATION1	VARCHAR2	(150)		Transfer descriptive flexfield column
TRANS_INFORMATION10	VARCHAR2	(150)		Transfer descriptive flexfield column
TRANS_INFORMATION11	VARCHAR2	(150)		Transfer descriptive flexfield column
TRANS_INFORMATION12	VARCHAR2	(150)		Transfer descriptive flexfield column
TRANS_INFORMATION13	VARCHAR2	(150)		Transfer descriptive flexfield column
TRANS_INFORMATION14	VARCHAR2	(150)		Transfer descriptive flexfield column
TRANS_INFORMATION15	VARCHAR2	(150)		Transfer descriptive flexfield column
TRANS_INFORMATION16	VARCHAR2	(150)		Transfer descriptive flexfield column
TRANS_INFORMATION17	VARCHAR2	(150)		Transfer descriptive flexfield column
TRANS_INFORMATION18	VARCHAR2	(150)		Transfer descriptive flexfield column
TRANS_INFORMATION19	VARCHAR2	(150)		Transfer descriptive flexfield column
TRANS_INFORMATION2	VARCHAR2	(150)		Transfer descriptive flexfield column
TRANS_INFORMATION20	VARCHAR2	(150)		Transfer descriptive flexfield column
TRANS_INFORMATION3	VARCHAR2	(150)		Transfer descriptive flexfield column
TRANS_INFORMATION4	VARCHAR2	(150)		Transfer descriptive flexfield column
TRANS_INFORMATION5	VARCHAR2	(150)		Transfer descriptive flexfield column
TRANS_INFORMATION6	VARCHAR2	(150)		Transfer descriptive flexfield column
TRANS_INFORMATION7	VARCHAR2	(150)		Transfer descriptive flexfield column
TRANS_INFORMATION8	VARCHAR2	(150)		Transfer descriptive flexfield column
TRANS_INFORMATION9	VARCHAR2	(150)		Transfer descriptive flexfield column
TRANSFER_DATE	DATE			Date on which the finance header is transferred to a financial system.
TRANSFER_MESSAGE	VARCHAR2	(240)		Message associated with the transfer of the finance header.
UNITARY_AMOUNT	NUMBER	(9)		The amount of training units being bought or used
BOOKING_DEAL_ID	NUMBER	(9)		Foreign key to OTA_BOOKING_DEALS
BOOKING_ID	NUMBER	(9)		Foreign key to OTA_DELEGATE_BOOKINGS
RESOURCE_ALLOCATION_ID	NUMBER	(9)		Foreign key to OTA_RESOURCE_ALLOCATIONS
RESOURCE_BOOKING_ID	NUMBER	(9)		Foreign key to OTA_RESOURCE_BOOKINGS
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
CREATED_BY	NUMBER	(15)		Standard Who Column
CREATION_DATE	DATE			Standard Who Column
TFL_INFORMATION_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
TFL_INFORMATION1	VARCHAR2	(150)		Descriptive flexfield segment column
TFL_INFORMATION2	VARCHAR2	(150)		Descriptive flexfield segment column
TFL_INFORMATION3	VARCHAR2	(150)		Descriptive flexfield segment column
TFL_INFORMATION4	VARCHAR2	(150)		Descriptive flexfield segment column
TFL_INFORMATION5	VARCHAR2	(150)		Descriptive flexfield segment column
TFL_INFORMATION6	VARCHAR2	(150)		Descriptive flexfield segment column
TFL_INFORMATION7	VARCHAR2	(150)		Descriptive flexfield segment column
TFL_INFORMATION8	VARCHAR2	(150)		Descriptive flexfield segment column
TFL_INFORMATION9	VARCHAR2	(150)		Descriptive flexfield segment column
TFL_INFORMATION10	VARCHAR2	(150)		Descriptive flexfield segment column
TFL_INFORMATION11	VARCHAR2	(150)		Descriptive flexfield segment column
TFL_INFORMATION12	VARCHAR2	(150)		Descriptive flexfield segment column
TFL_INFORMATION13	VARCHAR2	(150)		Descriptive flexfield segment column
TFL_INFORMATION14	VARCHAR2	(150)		Descriptive flexfield segment column
TFL_INFORMATION15	VARCHAR2	(150)		Descriptive flexfield segment column
TFL_INFORMATION16	VARCHAR2	(150)		Descriptive flexfield segment column
TFL_INFORMATION17	VARCHAR2	(150)		Descriptive flexfield segment column
TFL_INFORMATION18	VARCHAR2	(150)		Descriptive flexfield segment column
TFL_INFORMATION19	VARCHAR2	(150)		Descriptive flexfield segment column
TFL_INFORMATION20	VARCHAR2	(150)		Descriptive flexfield segment column

Query Text

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


SELECT FINANCE_LINE_ID
,      FINANCE_HEADER_ID
,      CANCELLED_FLAG
,      DATE_RAISED
,      LINE_TYPE
,      OBJECT_VERSION_NUMBER
,      SEQUENCE_NUMBER
,      TRANSFER_STATUS
,      COMMENTS
,      CURRENCY_CODE
,      MONEY_AMOUNT
,      STANDARD_AMOUNT
,      TRANS_INFORMATION_CATEGORY
,      TRANS_INFORMATION1
,      TRANS_INFORMATION10
,      TRANS_INFORMATION11
,      TRANS_INFORMATION12
,      TRANS_INFORMATION13
,      TRANS_INFORMATION14
,      TRANS_INFORMATION15
,      TRANS_INFORMATION16
,      TRANS_INFORMATION17
,      TRANS_INFORMATION18
,      TRANS_INFORMATION19
,      TRANS_INFORMATION2
,      TRANS_INFORMATION20
,      TRANS_INFORMATION3
,      TRANS_INFORMATION4
,      TRANS_INFORMATION5
,      TRANS_INFORMATION6
,      TRANS_INFORMATION7
,      TRANS_INFORMATION8
,      TRANS_INFORMATION9
,      TRANSFER_DATE
,      TRANSFER_MESSAGE
,      UNITARY_AMOUNT
,      BOOKING_DEAL_ID
,      BOOKING_ID
,      RESOURCE_ALLOCATION_ID
,      RESOURCE_BOOKING_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      TFL_INFORMATION_CATEGORY
,      TFL_INFORMATION1
,      TFL_INFORMATION2
,      TFL_INFORMATION3
,      TFL_INFORMATION4
,      TFL_INFORMATION5
,      TFL_INFORMATION6
,      TFL_INFORMATION7
,      TFL_INFORMATION8
,      TFL_INFORMATION9
,      TFL_INFORMATION10
,      TFL_INFORMATION11
,      TFL_INFORMATION12
,      TFL_INFORMATION13
,      TFL_INFORMATION14
,      TFL_INFORMATION15
,      TFL_INFORMATION16
,      TFL_INFORMATION17
,      TFL_INFORMATION18
,      TFL_INFORMATION19
,      TFL_INFORMATION20
FROM OTA.OTA_FINANCE_LINES;

Dependencies

[top of page]

OTA.OTA_FINANCE_LINES does not reference any database object

OTA.OTA_FINANCE_LINES is referenced by following:

APPS: OTA_FINANCE_LINES; OTA_FINANCE_LINES_WHO