[Home] [Help]
View: PO_TAX_HEADERS_DETAIL_V
Product: | PO - Purchasing |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT 'PO'
, POH.PO_HEADER_ID
, POH.SEGMENT1
, TO_NUMBER(NULL)
, POH.CURRENCY_CODE
, PO_TAX_SUMMARY_PKG.GET_RECOVERABLE_TAX(POH.PO_HEADER_ID
, NULL
, NULL
, 'PO'
, 'HEADER')
, PO_TAX_SUMMARY_PKG.GET_NONRECOVERABLE_TAX(POH.PO_HEADER_ID
, NULL
, NULL
, 'PO'
, 'HEADER')
, PO_TAX_SUMMARY_PKG.GET_HEADER_AMOUNT(POH.PO_HEADER_ID
, 'PO'
, POH.CURRENCY_CODE)
FROM PO_HEADERS POH UNION SELECT 'REL'
, POR.PO_RELEASE_ID
, POH.SEGMENT1
, POR.RELEASE_NUM
, POH.CURRENCY_CODE
, PO_TAX_SUMMARY_PKG.GET_RECOVERABLE_TAX(POR.PO_RELEASE_ID
, NULL
, NULL
, 'REL'
, 'HEADER')
, PO_TAX_SUMMARY_PKG.GET_NONRECOVERABLE_TAX(POR.PO_RELEASE_ID
, NULL
, NULL
, 'REL'
, 'HEADER')
, PO_TAX_SUMMARY_PKG.GET_HEADER_AMOUNT(POR.PO_RELEASE_ID
, 'REL'
, POH.CURRENCY_CODE)
FROM PO_RELEASES POR
, PO_HEADERS POH
WHERE POH.PO_HEADER_ID = POR.PO_HEADER_ID UNION SELECT 'REQ'
, PRH.REQUISITION_HEADER_ID
, PRH.SEGMENT1
, TO_NUMBER(NULL)
, PRH.CURRENCY_CODE
, PO_TAX_SUMMARY_PKG.GET_RECOVERABLE_TAX(PRH.REQUISITION_HEADER_ID
, NULL
, NULL
, 'REQ'
, 'HEADER')
, PO_TAX_SUMMARY_PKG.GET_NONRECOVERABLE_TAX(PRH.REQUISITION_HEADER_ID
, NULL
, NULL
, 'REQ'
, 'HEADER')
, PO_TAX_SUMMARY_PKG.GET_HEADER_AMOUNT(PRH.REQUISITION_HEADER_ID
, 'REQ'
, PRH.CURRENCY_CODE)
FROM PO_REQUISITION_HEADERS_V PRH
Columns
Name |
OBJECT_TYPE |
HEADER_ID |
DOCUMENT_NUM |
RELEASE |
CURRENCY_CODE |
RECOVERABLE_TAX |
NONRECOVERABLE_TAX |
AMOUNT |