View: PO_TAX_SHIPMENTS_DETAIL_V

View Text

SELECT 'PO'
, PLL.PO_HEADER_ID
, PLL.PO_LINE_ID
, PLL.LINE_LOCATION_ID
, PLL.SHIPMENT_NUM
, PLL.CANCEL_FLAG
, PLL.SHIP_TO_LOCATION_CODE
, PLL.CLOSED_CODE
, NVL(PLL.CURRENCY_CODE
, POH.CURRENCY_CODE)
, APT.NAME
, PO_TAX_SUMMARY_PKG.GET_RECOVERABLE_TAX(NULL
, NULL
, PLL.LINE_LOCATION_ID
, 'PO'
, 'SHIPMENT')
, PO_TAX_SUMMARY_PKG.GET_NONRECOVERABLE_TAX(NULL
, NULL
, PLL.LINE_LOCATION_ID
, 'PO'
, 'SHIPMENT')
, DECODE(POL.ORDER_TYPE_LOOKUP_CODE
, 'FIXED PRICE'
, (PLL.AMOUNT-NVL(PLL.AMOUNT_CANCELLED
, 0))
, 'RATE'
, (PLL.AMOUNT-NVL(PLL.AMOUNT_CANCELLED
, 0))
, ((PLL.QUANTITY-NVL(PLL.QUANTITY_CANCELLED
, 0))*PLL.UNIT_PRICE ))
, PLL.QUANTITY
, PLL.QUANTITY_CANCELLED
, PLL.AMOUNT
, PLL.AMOUNT_CANCELLED
FROM PO_LINE_LOCATIONS_V PLL
, PO_LINES POL
, PO_HEADERS POH
, AP_TAX_CODES APT
WHERE PLL.PO_HEADER_ID = POH.PO_HEADER_ID
AND PLL.PO_LINE_ID = POL.PO_LINE_ID
AND PLL.TAX_CODE_ID = APT.TAX_ID (+) UNION SELECT 'REL'
, PLL.PO_RELEASE_ID
, PLL.PO_LINE_ID
, PLL.LINE_LOCATION_ID
, PLL.SHIPMENT_NUM
, PLL.CANCEL_FLAG
, PLL.SHIP_TO_LOCATION_CODE
, PLL.CLOSED_CODE
, PLL.CURRENCY_CODE
, APT.NAME
, PO_TAX_SUMMARY_PKG.GET_RECOVERABLE_TAX(NULL
, NULL
, PLL.LINE_LOCATION_ID
, 'REL'
, 'SHIPMENT')
, PO_TAX_SUMMARY_PKG.GET_NONRECOVERABLE_TAX(NULL
, NULL
, PLL.LINE_LOCATION_ID
, 'REL'
, 'SHIPMENT')
, DECODE(POL.ORDER_TYPE_LOOKUP_CODE
, 'FIXED PRICE'
, (PLL.AMOUNT-NVL(PLL.AMOUNT_CANCELLED
, 0))
, ((PLL.QUANTITY-NVL(PLL.QUANTITY_CANCELLED
, 0))*PLL.PRICE_OVERRIDE ))
, PLL.QUANTITY
, PLL.QUANTITY_CANCELLED
, PLL.AMOUNT
, PLL.AMOUNT_CANCELLED
FROM PO_LINE_LOCATIONS_RELEASE_V PLL
, PO_LINES POL
, AP_TAX_CODES APT
WHERE PLL.TAX_CODE_ID = APT.TAX_ID(+)
AND PLL.PO_LINE_ID = POL.PO_LINE_ID UNION SELECT 'REQ'
, PRL.REQUISITION_HEADER_ID
, PRL.REQUISITION_LINE_ID
, PRL.REQUISITION_LINE_ID
, PRL.LINE_NUM
, PRL.CANCEL_FLAG
, PRL.DEST_ORGANIZATION
, PRL.CLOSED_CODE
, NVL(PRL.CURRENCY_CODE
, PRH.CURRENCY_CODE)
, APT.NAME
, PO_TAX_SUMMARY_PKG.GET_RECOVERABLE_TAX(NULL
, PRL.REQUISITION_LINE_ID
, NULL
, 'REQ'
, 'LINE')
, PO_TAX_SUMMARY_PKG.GET_NONRECOVERABLE_TAX(NULL
, PRL.REQUISITION_LINE_ID
, NULL
, 'REQ'
, 'LINE')
, DECODE(PRL.ORDER_TYPE_LOOKUP_CODE
, 'RATE'
, PRL.AMOUNT
, 'FIXED PRICE'
, PRL.AMOUNT
, PRL.QUANTITY*PRL.UNIT_PRICE)
, PRL.QUANTITY
, PRL.QUANTITY_CANCELLED
, PRL.AMOUNT
, TO_NUMBER(NULL)
FROM PO_REQUISITION_LINES_V PRL
, PO_REQUISITION_HEADERS_V PRH
, AP_TAX_CODES APT
WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
AND PRL.TAX_CODE_ID = APT.TAX_ID (+)

Columns