View: PO_ALERT_CONTRACT_VIEW2

Product:	PO - Purchasing
Description:	Contract purchase order total amount
Implementation/DBA Data:	APPS.PO_ALERT_CONTRACT_VIEW2

View Text

SELECT PH.PO_HEADER_ID
, NVL(SUM(DECODE(C.MINIMUM_ACCOUNTABLE_UNIT
, NULL
, ROUND ((PLL.QUANTITY - NVL(PLL.QUANTITY_CANCELLED
, 0)) * NVL(PLL.PRICE_OVERRIDE
, 0)
, C.PRECISION )
, ROUND ((PLL.QUANTITY - NVL(PLL.QUANTITY_CANCELLED
, 0)) * NVL(PLL.PRICE_OVERRIDE
, 0) / C.MINIMUM_ACCOUNTABLE_UNIT ) * C.MINIMUM_ACCOUNTABLE_UNIT ) )
, 0)
, PH.ORG_ID
FROM PO_LINE_LOCATIONS_ALL PLL
, PO_LINES_ALL PL
, FND_CURRENCIES C
, PO_HEADERS PH
WHERE PH.CURRENCY_CODE = C.CURRENCY_CODE
AND PL.PO_HEADER_ID = PLL.PO_HEADER_ID
AND PL.PO_LINE_ID = PLL.PO_LINE_ID
AND PL.CONTRACT_ID = PH.PO_HEADER_ID
AND PH.TYPE_LOOKUP_CODE = 'CONTRACT'
AND PH.APPROVED_DATE IS NOT NULL GROUP BY PH.PO_HEADER_ID
, PH.ORG_ID

Columns