Product: | OTA - Learning Management |
---|---|
Description: | View to list all information for Finance Headers |
Implementation/DBA Data: | APPS.OTA_FINANCE_HEADERS_V |
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')