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.

[Home] [Help]

VIEW: OTA.OTA_FINANCE_LINES#

Source

View Text - Preformatted


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

View Text - HTML Formatted

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