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_FINANCE_LINES_V

Product:	OTA - Learning Management
Description:	View to list all information for Finance Lines.
Implementation/DBA Data:	APPS.OTA_FINANCE_LINES_V

View Text

SELECT TFL.ROWID
, TFL.FINANCE_LINE_ID
, TFL.FINANCE_HEADER_ID
, TFL.SEQUENCE_NUMBER
, TFL.OBJECT_VERSION_NUMBER
, TFL.CANCELLED_FLAG
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, TFL.CANCELLED_FLAG)
, TFL.DATE_RAISED
, TFL.LINE_TYPE
, HR_GENERAL.DECODE_LOOKUP('FINANCE_LINE_TYPE'
, TFL.LINE_TYPE)
, TFL.CURRENCY_CODE
, TFL.STANDARD_AMOUNT
, TFL.TRANSFER_STATUS
, HR_GENERAL.DECODE_LOOKUP('GL_TRANSFER_STATUS'
, TFL.TRANSFER_STATUS)
, DECODE( TFL.TRANSFER_STATUS
, 'ST'
, 'Y'
, 'N')
, TFL.COMMENTS
, TFL.MONEY_AMOUNT
, TFL.TRANS_INFORMATION_CATEGORY
, TFL.TRANS_INFORMATION1
, TFL.TRANS_INFORMATION2
, TFL.TRANS_INFORMATION3
, TFL.TRANS_INFORMATION4
, TFL.TRANS_INFORMATION5
, TFL.TRANS_INFORMATION6
, TFL.TRANS_INFORMATION7
, TFL.TRANS_INFORMATION8
, TFL.TRANS_INFORMATION9
, TFL.TRANS_INFORMATION10
, TFL.TRANS_INFORMATION11
, TFL.TRANS_INFORMATION12
, TFL.TRANS_INFORMATION13
, TFL.TRANS_INFORMATION14
, TFL.TRANS_INFORMATION15
, TFL.TRANS_INFORMATION16
, TFL.TRANS_INFORMATION17
, TFL.TRANS_INFORMATION18
, TFL.TRANS_INFORMATION19
, TFL.TRANS_INFORMATION20
, TFL.TRANSFER_DATE
, TFL.TRANSFER_MESSAGE
, TFL.UNITARY_AMOUNT
, TFL.BOOKING_DEAL_ID
, OBD.NAME
, OBD.TYPE
, HR_GENERAL.DECODE_LOOKUP('BOOKING_DEAL_TYPE'
, OBD.TYPE)
, OBD.DISCOUNT_PERCENTAGE
, TPL.TRAINING_UNIT_TYPE
, HR_GENERAL.DECODE_LOOKUP('TRAINING_UNIT'
, TPL.TRAINING_UNIT_TYPE)
, TFL.BOOKING_ID
, DECODE(TDB.CUSTOMER_ID
, NULL
, 'I'
, 'E')
, DECODE(TDB.CUSTOMER_ID
, NULL
, TDB.DELEGATE_PERSON_ID
, TDB.DELEGATE_CONTACT_ID)
, DECODE(TDB.CUSTOMER_ID
, NULL
, PER.FULL_NAME
, OTA_TDB_BUS.GET_FULL_NAME (STU.LAST_NAME
, TTL.MEANING
, STU.FIRST_NAME
, TDB.BUSINESS_GROUP_ID
, STU.LAST_NAME_ALT
, STU.FIRST_NAME_ALT))
, TDB.NUMBER_OF_PLACES
, DECODE(TDB.CUSTOMER_ID
, NULL
, TDB.ORGANIZATION_ID
, TDB.CUSTOMER_ID)
, DECODE(TDB.CUSTOMER_ID
, NULL
, ORG.NAME
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50))
, DECODE(TDB.CUSTOMER_ID
, NULL
, SPN.FULL_NAME
, OTA_TDB_BUS.GET_FULL_NAME(CON.LAST_NAME
, CTI_LOOK.MEANING
, CON.FIRST_NAME
, TDB.BUSINESS_GROUP_ID
, CON.LAST_NAME_ALT
, CON.FIRST_NAME_ALT))
, ENT.TITLE
, EVT.COURSE_START_DATE
, TAV.VERSION_NAME
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TFL.LAST_UPDATE_DATE
, TFL.LAST_UPDATED_BY
, TFL.LAST_UPDATE_LOGIN
, TFL.CREATED_BY
, TFL.CREATION_DATE
, TFL.TFL_INFORMATION_CATEGORY
, TFL.TFL_INFORMATION1
, TFL.TFL_INFORMATION2
, TFL.TFL_INFORMATION3
, TFL.TFL_INFORMATION4
, TFL.TFL_INFORMATION5
, TFL.TFL_INFORMATION6
, TFL.TFL_INFORMATION7
, TFL.TFL_INFORMATION8
, TFL.TFL_INFORMATION9
, TFL.TFL_INFORMATION10
, TFL.TFL_INFORMATION11
, TFL.TFL_INFORMATION12
, TFL.TFL_INFORMATION13
, TFL.TFL_INFORMATION14
, TFL.TFL_INFORMATION15
, TFL.TFL_INFORMATION16
, TFL.TFL_INFORMATION17
, TFL.TFL_INFORMATION18
, TFL.TFL_INFORMATION19
, TFL.TFL_INFORMATION20
FROM PER_ALL_PEOPLE_F PER
, PER_ALL_PEOPLE_F SPN
, HR_ORGANIZATION_UNITS ORG
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, ( SELECT SUBSTRB( PARTY.PERSON_LAST_NAME
, 1
, 50) LAST_NAME
, SUBSTRB( PARTY.PERSON_FIRST_NAME
, 1
, 40) FIRST_NAME
, PARTY.PERSON_PRE_NAME_ADJUNCT TITLE
, ACCT_ROLE.CUST_ACCOUNT_ROLE_ID CONTACT_ID
, ACCT_ROLE.CUST_ACCOUNT_ID CUSTOMER_ID
, NULL FIRST_NAME_ALT
, NULL LAST_NAME_ALT
FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
, HZ_PARTIES PARTY
, HZ_RELATIONSHIPS REL
, HZ_ORG_CONTACTS ORG_CONT
, HZ_PARTIES REL_PARTY
, HZ_CUST_ACCOUNTS ROLE_ACCT
WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
AND REL.SUBJECT_ID = PARTY.PARTY_ID
AND REL.PARTY_ID = REL_PARTY.PARTY_ID
AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID ) CON
, AR_LOOKUPS CTI_LOOK
, AR_LOOKUPS TTL
, ( SELECT SUBSTRB( PARTY.PERSON_LAST_NAME
, 1
, 50) LAST_NAME
, SUBSTRB( PARTY.PERSON_FIRST_NAME
, 1
, 40) FIRST_NAME
, PARTY.PERSON_PRE_NAME_ADJUNCT TITLE
, ACCT_ROLE.CUST_ACCOUNT_ROLE_ID CONTACT_ID
, ACCT_ROLE.CUST_ACCOUNT_ID CUSTOMER_ID
, NULL FIRST_NAME_ALT
, NULL LAST_NAME_ALT
FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
, HZ_PARTIES PARTY
, HZ_RELATIONSHIPS REL
, HZ_ORG_CONTACTS ORG_CONT
, HZ_PARTIES REL_PARTY
, HZ_CUST_ACCOUNTS ROLE_ACCT
WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
AND REL.SUBJECT_ID = PARTY.PARTY_ID
AND REL.PARTY_ID = REL_PARTY.PARTY_ID
AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID ) STU
, OTA_ACTIVITY_VERSIONS_TL TAV
, OTA_EVENTS EVT
, OTA_EVENTS_TL ENT
, OTA_DELEGATE_BOOKINGS TDB
, OTA_PRICE_LISTS TPL
, OTA_BOOKING_DEALS OBD
, OTA_FINANCE_LINES TFL
, OTA_OFFERINGS OFF
, OTA_CATEGORY_USAGES OCU
WHERE TFL.LINE_TYPE = 'E'
AND TDB.BOOKING_ID = TFL.BOOKING_ID
AND OBD.BOOKING_DEAL_ID (+) = TFL.BOOKING_DEAL_ID
AND TPL.PRICE_LIST_ID (+) = OBD.PRICE_LIST_ID
AND TDB.DELEGATE_CONTACT_ID = STU.CONTACT_ID(+)
AND TDB.EVENT_ID = EVT.EVENT_ID
AND ENT.EVENT_ID = EVT.EVENT_ID
AND ENT.LANGUAGE = USERENV ('LANG')
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID(+)
AND TDB.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID (+)
AND TAV.ACTIVITY_VERSION_ID (+) = EVT.ACTIVITY_VERSION_ID
AND TAV.LANGUAGE (+) = USERENV ('LANG')
AND CON.CONTACT_ID (+) = TDB.CONTACT_ID
AND CTI_LOOK.LOOKUP_TYPE (+) = 'CONTACT_TITLE'
AND CTI_LOOK.LOOKUP_CODE (+) = CON.TITLE
AND TTL.LOOKUP_CODE (+) = STU.TITLE
AND TTL.LOOKUP_TYPE (+) = 'CONTACT_TITLE'
AND TDB.ORGANIZATION_ID = ORG.ORGANIZATION_ID(+)
AND TDB.SPONSOR_PERSON_ID = SPN.PERSON_ID(+)
AND TDB.DATE_BOOKING_PLACED BETWEEN NVL(SPN.EFFECTIVE_START_DATE
, TDB.DATE_BOOKING_PLACED)
AND NVL(SPN.EFFECTIVE_END_DATE
, TDB.DATE_BOOKING_PLACED)
AND TDB.DELEGATE_PERSON_ID = PER.PERSON_ID(+)
AND OCU.CATEGORY_USAGE_ID(+) = OFF.DELIVERY_MODE_ID
AND EVT.PARENT_OFFERING_ID = OFF.OFFERING_ID(+)
AND ( ( OCU.SYNCHRONOUS_FLAG = 'Y'
AND (NVL(EVT.COURSE_START_DATE
, TDB.DATE_BOOKING_PLACED) BETWEEN NVL(PER.EFFECTIVE_START_DATE
, NVL(EVT.COURSE_START_DATE
, TDB.DATE_BOOKING_PLACED))
AND NVL(PER.EFFECTIVE_END_DATE
, NVL(EVT.COURSE_START_DATE
, TDB.DATE_BOOKING_PLACED))) ) OR (TDB.DATE_BOOKING_PLACED BETWEEN NVL(PER.EFFECTIVE_START_DATE
, TDB.DATE_BOOKING_PLACED)
AND NVL(PER.EFFECTIVE_END_DATE
, TDB.DATE_BOOKING_PLACED)
AND OCU.SYNCHRONOUS_FLAG = 'N') OR (NVL(EVT.COURSE_START_DATE
, TDB.DATE_BOOKING_PLACED) BETWEEN NVL(PER.EFFECTIVE_START_DATE
, NVL(EVT.COURSE_START_DATE
, TDB.DATE_BOOKING_PLACED))
AND NVL(PER.EFFECTIVE_END_DATE
, NVL(EVT.COURSE_START_DATE
, TDB.DATE_BOOKING_PLACED))
AND EVT.PARENT_OFFERING_ID IS NULL)) UNION SELECT TFL.ROWID
, TFL.FINANCE_LINE_ID
, TFL.FINANCE_HEADER_ID
, TFL.SEQUENCE_NUMBER
, TFL.OBJECT_VERSION_NUMBER
, TFL.CANCELLED_FLAG
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, TFL.CANCELLED_FLAG)
, TFL.DATE_RAISED
, TFL.LINE_TYPE
, HR_GENERAL.DECODE_LOOKUP('FINANCE_LINE_TYPE'
, TFL.LINE_TYPE)
, TFL.CURRENCY_CODE
, TFL.STANDARD_AMOUNT
, TFL.TRANSFER_STATUS
, HR_GENERAL.DECODE_LOOKUP('GL_TRANSFER_STATUS'
, TFL.TRANSFER_STATUS)
, DECODE( TFL.TRANSFER_STATUS
, 'ST'
, 'Y'
, 'N')
, TFL.COMMENTS
, TFL.MONEY_AMOUNT
, TFL.TRANS_INFORMATION_CATEGORY
, TFL.TRANS_INFORMATION1
, TFL.TRANS_INFORMATION2
, TFL.TRANS_INFORMATION3
, TFL.TRANS_INFORMATION4
, TFL.TRANS_INFORMATION5
, TFL.TRANS_INFORMATION6
, TFL.TRANS_INFORMATION7
, TFL.TRANS_INFORMATION8
, TFL.TRANS_INFORMATION9
, TFL.TRANS_INFORMATION10
, TFL.TRANS_INFORMATION11
, TFL.TRANS_INFORMATION12
, TFL.TRANS_INFORMATION13
, TFL.TRANS_INFORMATION14
, TFL.TRANS_INFORMATION15
, TFL.TRANS_INFORMATION16
, TFL.TRANS_INFORMATION17
, TFL.TRANS_INFORMATION18
, TFL.TRANS_INFORMATION19
, TFL.TRANS_INFORMATION20
, TFL.TRANSFER_DATE
, TFL.TRANSFER_MESSAGE
, TFL.UNITARY_AMOUNT
, TFL.BOOKING_DEAL_ID
, OBD.NAME
, OBD.TYPE
, OBD.TBD_TYPE_MEANING
, OBD.DISCOUNT_PERCENTAGE
, TPL.TRAINING_UNIT_TYPE
, HR_GENERAL.DECODE_LOOKUP('TRAINING_UNIT'
, TPL.TRAINING_UNIT_TYPE)
, TFL.BOOKING_ID
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, CUST_ACCT.CUST_ACCOUNT_ID
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_DATE(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TFL.LAST_UPDATE_DATE
, TFL.LAST_UPDATED_BY
, TFL.LAST_UPDATE_LOGIN
, TFL.CREATED_BY
, TFL.CREATION_DATE
, TFL.TFL_INFORMATION_CATEGORY
, TFL.TFL_INFORMATION1
, TFL.TFL_INFORMATION2
, TFL.TFL_INFORMATION3
, TFL.TFL_INFORMATION4
, TFL.TFL_INFORMATION5
, TFL.TFL_INFORMATION6
, TFL.TFL_INFORMATION7
, TFL.TFL_INFORMATION8
, TFL.TFL_INFORMATION9
, TFL.TFL_INFORMATION10
, TFL.TFL_INFORMATION11
, TFL.TFL_INFORMATION12
, TFL.TFL_INFORMATION13
, TFL.TFL_INFORMATION14
, TFL.TFL_INFORMATION15
, TFL.TFL_INFORMATION16
, TFL.TFL_INFORMATION17
, TFL.TFL_INFORMATION18
, TFL.TFL_INFORMATION19
, TFL.TFL_INFORMATION20
FROM OTA_FINANCE_LINES TFL
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, OTA_BOOKING_DEALS_V OBD
, OTA_PRICE_LISTS TPL
WHERE TFL.LINE_TYPE = 'P'
AND CUST_ACCT.CUST_ACCOUNT_ID = OBD.CUSTOMER_ID
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND OBD.BOOKING_DEAL_ID (+) = TFL.BOOKING_DEAL_ID
AND TPL.PRICE_LIST_ID (+) = OBD.PRICE_LIST_ID UNION SELECT TFL.ROWID
, TFL.FINANCE_LINE_ID
, TFL.FINANCE_HEADER_ID
, TFL.SEQUENCE_NUMBER
, TFL.OBJECT_VERSION_NUMBER
, TFL.CANCELLED_FLAG
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, TFL.CANCELLED_FLAG)
, TFL.DATE_RAISED
, TFL.LINE_TYPE
, HR_GENERAL.DECODE_LOOKUP('FINANCE_LINE_TYPE'
, TFL.LINE_TYPE)
, TFL.CURRENCY_CODE
, TFL.STANDARD_AMOUNT
, TFL.TRANSFER_STATUS
, HR_GENERAL.DECODE_LOOKUP('GL_TRANSFER_STATUS'
, TFL.TRANSFER_STATUS)
, DECODE( TFL.TRANSFER_STATUS
, 'ST'
, 'Y'
, 'N')
, TFL.COMMENTS
, TFL.MONEY_AMOUNT
, TFL.TRANS_INFORMATION_CATEGORY
, TFL.TRANS_INFORMATION1
, TFL.TRANS_INFORMATION2
, TFL.TRANS_INFORMATION3
, TFL.TRANS_INFORMATION4
, TFL.TRANS_INFORMATION5
, TFL.TRANS_INFORMATION6
, TFL.TRANS_INFORMATION7
, TFL.TRANS_INFORMATION8
, TFL.TRANS_INFORMATION9
, TFL.TRANS_INFORMATION10
, TFL.TRANS_INFORMATION11
, TFL.TRANS_INFORMATION12
, TFL.TRANS_INFORMATION13
, TFL.TRANS_INFORMATION14
, TFL.TRANS_INFORMATION15
, TFL.TRANS_INFORMATION16
, TFL.TRANS_INFORMATION17
, TFL.TRANS_INFORMATION18
, TFL.TRANS_INFORMATION19
, TFL.TRANS_INFORMATION20
, TFL.TRANSFER_DATE
, TFL.TRANSFER_MESSAGE
, TFL.UNITARY_AMOUNT
, TFL.BOOKING_DEAL_ID
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, ENT.TITLE
, EVT.COURSE_START_DATE
, TAV.VERSION_NAME
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TFL.RESOURCE_BOOKING_ID
, TSR.NAME
, TSR.RESOURCE_TYPE_MEANING
, TSR.VENDOR_ID
, TSR.VENDOR_NAME
, TRB.REQUIRED_DATE_FROM
, TRB.REQUIRED_DATE_TO
, TFL.LAST_UPDATE_DATE
, TFL.LAST_UPDATED_BY
, TFL.LAST_UPDATE_LOGIN
, TFL.CREATED_BY
, TFL.CREATION_DATE
, TFL.TFL_INFORMATION_CATEGORY
, TFL.TFL_INFORMATION1
, TFL.TFL_INFORMATION2
, TFL.TFL_INFORMATION3
, TFL.TFL_INFORMATION4
, TFL.TFL_INFORMATION5
, TFL.TFL_INFORMATION6
, TFL.TFL_INFORMATION7
, TFL.TFL_INFORMATION8
, TFL.TFL_INFORMATION9
, TFL.TFL_INFORMATION10
, TFL.TFL_INFORMATION11
, TFL.TFL_INFORMATION12
, TFL.TFL_INFORMATION13
, TFL.TFL_INFORMATION14
, TFL.TFL_INFORMATION15
, TFL.TFL_INFORMATION16
, TFL.TFL_INFORMATION17
, TFL.TFL_INFORMATION18
, TFL.TFL_INFORMATION19
, TFL.TFL_INFORMATION20
FROM OTA_FINANCE_LINES TFL
, OTA_RESOURCE_BOOKINGS TRB
, OTA_EVENTS EVT
, OTA_EVENTS_TL ENT
, OTA_ACTIVITY_VERSIONS_TL TAV
, OTA_SUPPLIABLE_RESOURCES_V TSR
WHERE TFL.LINE_TYPE = 'V'
AND EVT.EVENT_ID (+) = TRB.EVENT_ID
AND ENT.EVENT_ID (+) = EVT.EVENT_ID
AND ENT.LANGUAGE (+) = USERENV ('LANG')
AND TRB.RESOURCE_BOOKING_ID = TFL.RESOURCE_BOOKING_ID
AND TAV.ACTIVITY_VERSION_ID (+) = EVT.ACTIVITY_VERSION_ID
AND TAV.LANGUAGE (+) = USERENV ('LANG')
AND TSR.SUPPLIED_RESOURCE_ID (+) = TRB.SUPPLIED_RESOURCE_ID UNION SELECT TFL.ROWID
, TFL.FINANCE_LINE_ID
, TFL.FINANCE_HEADER_ID
, TFL.SEQUENCE_NUMBER
, TFL.OBJECT_VERSION_NUMBER
, TFL.CANCELLED_FLAG
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, TFL.CANCELLED_FLAG)
, TFL.DATE_RAISED
, TFL.LINE_TYPE
, HR_GENERAL.DECODE_LOOKUP('FINANCE_LINE_TYPE'
, TFL.LINE_TYPE)
, TFL.CURRENCY_CODE
, TFL.STANDARD_AMOUNT
, TFL.TRANSFER_STATUS
, HR_GENERAL.DECODE_LOOKUP('GL_TRANSFER_STATUS'
, TFL.TRANSFER_STATUS)
, DECODE( TFL.TRANSFER_STATUS
, 'ST'
, 'Y'
, 'N')
, TFL.COMMENTS
, TFL.MONEY_AMOUNT
, TFL.TRANS_INFORMATION_CATEGORY
, TFL.TRANS_INFORMATION1
, TFL.TRANS_INFORMATION2
, TFL.TRANS_INFORMATION3
, TFL.TRANS_INFORMATION4
, TFL.TRANS_INFORMATION5
, TFL.TRANS_INFORMATION6
, TFL.TRANS_INFORMATION7
, TFL.TRANS_INFORMATION8
, TFL.TRANS_INFORMATION9
, TFL.TRANS_INFORMATION10
, TFL.TRANS_INFORMATION11
, TFL.TRANS_INFORMATION12
, TFL.TRANS_INFORMATION13
, TFL.TRANS_INFORMATION14
, TFL.TRANS_INFORMATION15
, TFL.TRANS_INFORMATION16
, TFL.TRANS_INFORMATION17
, TFL.TRANS_INFORMATION18
, TFL.TRANS_INFORMATION19
, TFL.TRANS_INFORMATION20
, TFL.TRANSFER_DATE
, TFL.TRANSFER_MESSAGE
, TFL.UNITARY_AMOUNT
, TFL.BOOKING_DEAL_ID
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_DATE(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TFL.RESOURCE_BOOKING_ID
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TFL.LAST_UPDATE_DATE
, TFL.LAST_UPDATED_BY
, TFL.LAST_UPDATE_LOGIN
, TFL.CREATED_BY
, TFL.CREATION_DATE
, TFL.TFL_INFORMATION_CATEGORY
, TFL.TFL_INFORMATION1
, TFL.TFL_INFORMATION2
, TFL.TFL_INFORMATION3
, TFL.TFL_INFORMATION4
, TFL.TFL_INFORMATION5
, TFL.TFL_INFORMATION6
, TFL.TFL_INFORMATION7
, TFL.TFL_INFORMATION8
, TFL.TFL_INFORMATION9
, TFL.TFL_INFORMATION10
, TFL.TFL_INFORMATION11
, TFL.TFL_INFORMATION12
, TFL.TFL_INFORMATION13
, TFL.TFL_INFORMATION14
, TFL.TFL_INFORMATION15
, TFL.TFL_INFORMATION16
, TFL.TFL_INFORMATION17
, TFL.TFL_INFORMATION18
, TFL.TFL_INFORMATION19
, TFL.TFL_INFORMATION20
FROM OTA_FINANCE_LINES TFL
WHERE TFL.LINE_TYPE NOT IN ('E'
, 'R'
, 'V'
, 'P')

Columns

Name
ROW_ID
FINANCE_LINE_ID
FINANCE_HEADER_ID
SEQUENCE_NUMBER
OBJECT_VERSION_NUMBER
CANCELLED_FLAG
CANCELLED_FLAG_MEANING
DATE_RAISED
LINE_TYPE
LINE_TYPE_MEANING
CURRENCY_CODE
STANDARD_AMOUNT
TRANSFER_STATUS
TRANSFER_STATUS_MEANING
TRANSFERRED
COMMENTS
MONEY_AMOUNT
TRANS_INFORMATION_CATEGORY
TRANS_INFORMATION1
TRANS_INFORMATION2
TRANS_INFORMATION3
TRANS_INFORMATION4
TRANS_INFORMATION5
TRANS_INFORMATION6
TRANS_INFORMATION7
TRANS_INFORMATION8
TRANS_INFORMATION9
TRANS_INFORMATION10
TRANS_INFORMATION11
TRANS_INFORMATION12
TRANS_INFORMATION13
TRANS_INFORMATION14
TRANS_INFORMATION15
TRANS_INFORMATION16
TRANS_INFORMATION17
TRANS_INFORMATION18
TRANS_INFORMATION19
TRANS_INFORMATION20
TRANSFER_DATE
TRANSFER_MESSAGE
UNITARY_AMOUNT
BOOKING_DEAL_ID
BOOKING_DEAL_NAME
BOOKING_DEAL_TYPE
BOOKING_DEAL_TYPE_MEANING
BOOKING_DEAL_DISCOUNT
BOOKING_DEAL_TRAIN_UNIT
TRAINING_UNIT_MEANING
BOOKING_ID
ENROLLMENT_TYPE
DELEGATE_ID
DELEGATE_FULL_NAME
DELEGATE_QUANTITY
DELEGATE_CUST_ORG_ID
DELEGATE_CUST_ORG_NAME
DELEGATE_CONTACT_FULL_NAME
EVENT_TITLE
EVENT_START_DATE
EVENT_ACTIVITY
RESOURCE_ALLOCATION_ID
ALLOCATION_DATE_FROM
ALLOCATION_DATE_TO
RESOURCE_BOOKING_ID
RESOURCE_NAME
RESOURCE_TYPE_MEANING
VENDOR_ID
VENDOR_NAME
RESOURCE_BOOKING_START
RESOURCE_BOOKING_END
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