View: PO_TAX_HEADERS_DETAIL_V

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