[Home] [Help]
View: PO_TAX_LINES_DETAIL_V
Product: | PO - Purchasing |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT 'PO'
, POL.PO_HEADER_ID
, POL.PO_LINE_ID
, POL.LINE_NUM
, POL.ITEM_NUMBER
, POH.CURRENCY_CODE
, POL.CLOSED_CODE
, POL.CANCEL_FLAG
, PO_TAX_SUMMARY_PKG.GET_RECOVERABLE_TAX(NULL
, POL.PO_LINE_ID
, NULL
, 'PO'
, 'LINE')
, PO_TAX_SUMMARY_PKG.GET_NONRECOVERABLE_TAX(NULL
, POL.PO_LINE_ID
, NULL
, 'PO'
, 'LINE')
, POL.ORG_ID
FROM PO_LINES_V POL
, PO_HEADERS_ALL POH
WHERE POL.PO_HEADER_ID = POH.PO_HEADER_ID
Columns
Name |
OBJECT_TYPE |
HEADER_ID |
LINE_ID |
LINE_NUM |
ITEM_NUM |
CURRENCY_CODE |
CLOSED_CODE |
CANCEL_FLAG |
RECOVERABLE_TAX |
NONRECOVERABLE_TAX |
ORG_ID |