VIEW: APPS.OTA_FINANCE_HEADERS_V

Source

View Text - Preformatted

SELECT TFH.ROWID , TFH.FINANCE_HEADER_ID , TFH.OBJECT_VERSION_NUMBER , ORG.BUSINESS_GROUP_ID , TFH.SUPERCEDING_HEADER_ID , TFH.AUTHORIZER_PERSON_ID , USR2.USER_NAME , TFH.ORGANIZATION_ID , ORG.NAME , TFH.ADMINISTRATOR , USR.USER_NAME , TFH.CANCELLED_FLAG , TFH.CURRENCY_CODE , OTA_TFH_API_BUSINESS_RULES2.INVOICE_FULL_AMOUNT (TFH.FINANCE_HEADER_ID,TFH.CURRENCY_CODE) , TFH.DATE_RAISED , TFH.PAYMENT_STATUS_FLAG , TFH.TRANSFER_STATUS , HR_GENERAL.DECODE_LOOKUP('GL_TRANSFER_STATUS',TFH.TRANSFER_STATUS) , TFH.TYPE , HR_GENERAL.DECODE_LOOKUP('FINANCE_HEADER_TYPE',TFH.TYPE) , TFH.RECEIVABLE_TYPE , TFH.COMMENTS , TFH.EXTERNAL_REFERENCE , TFH.INVOICE_ADDRESS , TFH.INVOICE_CONTACT , TFH.PAYMENT_METHOD , HR_GENERAL.DECODE_LOOKUP('PAYMENT_METHOD',TFH.PAYMENT_METHOD) , TFH.PYM_ATTRIBUTE1 , TFH.PYM_ATTRIBUTE2 , TFH.PYM_ATTRIBUTE3 , TFH.PYM_ATTRIBUTE4 , TFH.PYM_ATTRIBUTE5 , TFH.PYM_ATTRIBUTE6 , TFH.PYM_ATTRIBUTE7 , TFH.PYM_ATTRIBUTE8 , TFH.PYM_ATTRIBUTE9 , TFH.PYM_ATTRIBUTE10 , TFH.PYM_ATTRIBUTE11 , TFH.PYM_ATTRIBUTE12 , TFH.PYM_ATTRIBUTE13 , TFH.PYM_ATTRIBUTE14 , TFH.PYM_ATTRIBUTE15 , TFH.PYM_ATTRIBUTE16 , TFH.PYM_ATTRIBUTE17 , TFH.PYM_ATTRIBUTE18 , TFH.PYM_ATTRIBUTE19 , TFH.PYM_ATTRIBUTE20 , TFH.PYM_INFORMATION_CATEGORY , TFH.TRANSFER_DATE , TFH.TRANSFER_MESSAGE , TFH.VENDOR_ID , VEN.VENDOR_NAME , TFH.CONTACT_ID , TFH.ADDRESS_ID , TFH.CUSTOMER_ID , substrb(PARTY.party_name,1,50) CUSTOMER_NAME , TFH.LAST_UPDATE_DATE , TFH.LAST_UPDATED_BY , TFH.LAST_UPDATE_LOGIN , TFH.CREATED_BY , TFH.CREATION_DATE , TFH.TFH_INFORMATION_CATEGORY , TFH.TFH_INFORMATION1 , TFH.TFH_INFORMATION2 , TFH.TFH_INFORMATION3 , TFH.TFH_INFORMATION4 , TFH.TFH_INFORMATION5 , TFH.TFH_INFORMATION6 , TFH.TFH_INFORMATION7 , TFH.TFH_INFORMATION8 , TFH.TFH_INFORMATION9 , TFH.TFH_INFORMATION10 , TFH.TFH_INFORMATION11 , TFH.TFH_INFORMATION12 , TFH.TFH_INFORMATION13 , TFH.TFH_INFORMATION14 , TFH.TFH_INFORMATION15 , TFH.TFH_INFORMATION16 , TFH.TFH_INFORMATION17 , TFH.TFH_INFORMATION18 , TFH.TFH_INFORMATION19 , TFH.TFH_INFORMATION20 , TFH.RECEIVING_COST_CENTER , TFH.PAYING_COST_CENTER , TFH.TRANSFER_FROM_SET_OF_BOOKS_ID , TFH.TRANSFER_TO_SET_OF_BOOKS_ID , TFH.FROM_SEGMENT1 , TFH.FROM_SEGMENT2 , TFH.FROM_SEGMENT3 , TFH.FROM_SEGMENT4 , TFH.FROM_SEGMENT5 , TFH.FROM_SEGMENT6 , TFH.FROM_SEGMENT7 , TFH.FROM_SEGMENT8 , TFH.FROM_SEGMENT9 , TFH.FROM_SEGMENT10 , TFH.FROM_SEGMENT11 , TFH.FROM_SEGMENT12 , TFH.FROM_SEGMENT13 , TFH.FROM_SEGMENT14 , TFH.FROM_SEGMENT15 , TFH.FROM_SEGMENT16 , TFH.FROM_SEGMENT17 , TFH.FROM_SEGMENT18 , TFH.FROM_SEGMENT19 , TFH.FROM_SEGMENT20 , TFH.FROM_SEGMENT21 , TFH.FROM_SEGMENT22 , TFH.FROM_SEGMENT23 , TFH.FROM_SEGMENT24 , TFH.FROM_SEGMENT25 , TFH.FROM_SEGMENT26 , TFH.FROM_SEGMENT27 , TFH.FROM_SEGMENT28 , TFH.FROM_SEGMENT29 , TFH.FROM_SEGMENT30 , TFH.TO_SEGMENT1 , TFH.TO_SEGMENT2 , TFH.TO_SEGMENT3 , TFH.TO_SEGMENT4 , TFH.TO_SEGMENT5 , TFH.TO_SEGMENT6 , TFH.TO_SEGMENT7 , TFH.TO_SEGMENT8 , TFH.TO_SEGMENT9 , TFH.TO_SEGMENT10 , TFH.TO_SEGMENT11 , TFH.TO_SEGMENT12 , TFH.TO_SEGMENT13 , TFH.TO_SEGMENT14 , TFH.TO_SEGMENT15 , TFH.TO_SEGMENT16 , TFH.TO_SEGMENT17 , TFH.TO_SEGMENT18 , TFH.TO_SEGMENT19 , TFH.TO_SEGMENT20 , TFH.TO_SEGMENT21 , TFH.TO_SEGMENT22 , TFH.TO_SEGMENT23 , TFH.TO_SEGMENT24 , TFH.TO_SEGMENT25 , TFH.TO_SEGMENT26 , TFH.TO_SEGMENT27 , TFH.TO_SEGMENT28 , TFH.TO_SEGMENT29 , TFH.TO_SEGMENT30 , TFH.TRANSFER_FROM_CC_ID , TFH.TRANSFER_TO_CC_ID FROM FND_USER USR , FND_USER USR2 , HZ_PARTIES party, HZ_CUST_ACCOUNTS cust_acct, PO_VENDORS VEN , HR_ALL_ORGANIZATION_UNITS ORG , HR_ALL_ORGANIZATION_UNITS_TL HAOTL , OTA_FINANCE_HEADERS TFH WHERE USR.USER_ID = TFH.ADMINISTRATOR AND USR2.USER_ID (+) = TFH.AUTHORIZER_PERSON_ID AND CUST_ACCT.party_id = PARTY.party_id (+) AND CUST_ACCT.cust_account_id (+) = TFH.CUSTOMER_ID AND VEN.VENDOR_ID (+) = TFH.VENDOR_ID AND ORG.ORGANIZATION_ID = TFH.ORGANIZATION_ID AND HAOTL.ORGANIZATION_ID = ORG.ORGANIZATION_ID AND HAOTL.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT TFH.ROWID
, TFH.FINANCE_HEADER_ID
, TFH.OBJECT_VERSION_NUMBER
, ORG.BUSINESS_GROUP_ID
, TFH.SUPERCEDING_HEADER_ID
, TFH.AUTHORIZER_PERSON_ID
, USR2.USER_NAME
, TFH.ORGANIZATION_ID
, ORG.NAME
, TFH.ADMINISTRATOR
, USR.USER_NAME
, TFH.CANCELLED_FLAG
, TFH.CURRENCY_CODE
, OTA_TFH_API_BUSINESS_RULES2.INVOICE_FULL_AMOUNT (TFH.FINANCE_HEADER_ID
, TFH.CURRENCY_CODE)
, TFH.DATE_RAISED
, TFH.PAYMENT_STATUS_FLAG
, TFH.TRANSFER_STATUS
, HR_GENERAL.DECODE_LOOKUP('GL_TRANSFER_STATUS'
, TFH.TRANSFER_STATUS)
, TFH.TYPE
, HR_GENERAL.DECODE_LOOKUP('FINANCE_HEADER_TYPE'
, TFH.TYPE)
, TFH.RECEIVABLE_TYPE
, TFH.COMMENTS
, TFH.EXTERNAL_REFERENCE
, TFH.INVOICE_ADDRESS
, TFH.INVOICE_CONTACT
, TFH.PAYMENT_METHOD
, HR_GENERAL.DECODE_LOOKUP('PAYMENT_METHOD'
, TFH.PAYMENT_METHOD)
, TFH.PYM_ATTRIBUTE1
, TFH.PYM_ATTRIBUTE2
, TFH.PYM_ATTRIBUTE3
, TFH.PYM_ATTRIBUTE4
, TFH.PYM_ATTRIBUTE5
, TFH.PYM_ATTRIBUTE6
, TFH.PYM_ATTRIBUTE7
, TFH.PYM_ATTRIBUTE8
, TFH.PYM_ATTRIBUTE9
, TFH.PYM_ATTRIBUTE10
, TFH.PYM_ATTRIBUTE11
, TFH.PYM_ATTRIBUTE12
, TFH.PYM_ATTRIBUTE13
, TFH.PYM_ATTRIBUTE14
, TFH.PYM_ATTRIBUTE15
, TFH.PYM_ATTRIBUTE16
, TFH.PYM_ATTRIBUTE17
, TFH.PYM_ATTRIBUTE18
, TFH.PYM_ATTRIBUTE19
, TFH.PYM_ATTRIBUTE20
, TFH.PYM_INFORMATION_CATEGORY
, TFH.TRANSFER_DATE
, TFH.TRANSFER_MESSAGE
, TFH.VENDOR_ID
, VEN.VENDOR_NAME
, TFH.CONTACT_ID
, TFH.ADDRESS_ID
, TFH.CUSTOMER_ID
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50) CUSTOMER_NAME
, TFH.LAST_UPDATE_DATE
, TFH.LAST_UPDATED_BY
, TFH.LAST_UPDATE_LOGIN
, TFH.CREATED_BY
, TFH.CREATION_DATE
, TFH.TFH_INFORMATION_CATEGORY
, TFH.TFH_INFORMATION1
, TFH.TFH_INFORMATION2
, TFH.TFH_INFORMATION3
, TFH.TFH_INFORMATION4
, TFH.TFH_INFORMATION5
, TFH.TFH_INFORMATION6
, TFH.TFH_INFORMATION7
, TFH.TFH_INFORMATION8
, TFH.TFH_INFORMATION9
, TFH.TFH_INFORMATION10
, TFH.TFH_INFORMATION11
, TFH.TFH_INFORMATION12
, TFH.TFH_INFORMATION13
, TFH.TFH_INFORMATION14
, TFH.TFH_INFORMATION15
, TFH.TFH_INFORMATION16
, TFH.TFH_INFORMATION17
, TFH.TFH_INFORMATION18
, TFH.TFH_INFORMATION19
, TFH.TFH_INFORMATION20
, TFH.RECEIVING_COST_CENTER
, TFH.PAYING_COST_CENTER
, TFH.TRANSFER_FROM_SET_OF_BOOKS_ID
, TFH.TRANSFER_TO_SET_OF_BOOKS_ID
, TFH.FROM_SEGMENT1
, TFH.FROM_SEGMENT2
, TFH.FROM_SEGMENT3
, TFH.FROM_SEGMENT4
, TFH.FROM_SEGMENT5
, TFH.FROM_SEGMENT6
, TFH.FROM_SEGMENT7
, TFH.FROM_SEGMENT8
, TFH.FROM_SEGMENT9
, TFH.FROM_SEGMENT10
, TFH.FROM_SEGMENT11
, TFH.FROM_SEGMENT12
, TFH.FROM_SEGMENT13
, TFH.FROM_SEGMENT14
, TFH.FROM_SEGMENT15
, TFH.FROM_SEGMENT16
, TFH.FROM_SEGMENT17
, TFH.FROM_SEGMENT18
, TFH.FROM_SEGMENT19
, TFH.FROM_SEGMENT20
, TFH.FROM_SEGMENT21
, TFH.FROM_SEGMENT22
, TFH.FROM_SEGMENT23
, TFH.FROM_SEGMENT24
, TFH.FROM_SEGMENT25
, TFH.FROM_SEGMENT26
, TFH.FROM_SEGMENT27
, TFH.FROM_SEGMENT28
, TFH.FROM_SEGMENT29
, TFH.FROM_SEGMENT30
, TFH.TO_SEGMENT1
, TFH.TO_SEGMENT2
, TFH.TO_SEGMENT3
, TFH.TO_SEGMENT4
, TFH.TO_SEGMENT5
, TFH.TO_SEGMENT6
, TFH.TO_SEGMENT7
, TFH.TO_SEGMENT8
, TFH.TO_SEGMENT9
, TFH.TO_SEGMENT10
, TFH.TO_SEGMENT11
, TFH.TO_SEGMENT12
, TFH.TO_SEGMENT13
, TFH.TO_SEGMENT14
, TFH.TO_SEGMENT15
, TFH.TO_SEGMENT16
, TFH.TO_SEGMENT17
, TFH.TO_SEGMENT18
, TFH.TO_SEGMENT19
, TFH.TO_SEGMENT20
, TFH.TO_SEGMENT21
, TFH.TO_SEGMENT22
, TFH.TO_SEGMENT23
, TFH.TO_SEGMENT24
, TFH.TO_SEGMENT25
, TFH.TO_SEGMENT26
, TFH.TO_SEGMENT27
, TFH.TO_SEGMENT28
, TFH.TO_SEGMENT29
, TFH.TO_SEGMENT30
, TFH.TRANSFER_FROM_CC_ID
, TFH.TRANSFER_TO_CC_ID
FROM FND_USER USR
, FND_USER USR2
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, PO_VENDORS VEN
, HR_ALL_ORGANIZATION_UNITS ORG
, HR_ALL_ORGANIZATION_UNITS_TL HAOTL
, OTA_FINANCE_HEADERS TFH
WHERE USR.USER_ID = TFH.ADMINISTRATOR
AND USR2.USER_ID (+) = TFH.AUTHORIZER_PERSON_ID
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID (+)
AND CUST_ACCT.CUST_ACCOUNT_ID (+) = TFH.CUSTOMER_ID
AND VEN.VENDOR_ID (+) = TFH.VENDOR_ID
AND ORG.ORGANIZATION_ID = TFH.ORGANIZATION_ID
AND HAOTL.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND HAOTL.LANGUAGE = USERENV('LANG')