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.

VIEW: APPS.OTA_FINANCE_LINES_V

Source

View Text - Preformatted


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')

View Text - HTML Formatted

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')