View: PO_ALERT_SCHEDULED_VIEW

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

View Text

SELECT POH.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)
, POH.ORG_ID
FROM PO_LINE_LOCATIONS_ALL PLL
, FND_CURRENCIES C
, PO_HEADERS POH
WHERE POH.CURRENCY_CODE = C.CURRENCY_CODE
AND NVL(POH.CANCEL_FLAG
, 'N') = 'N'
AND NVL(POH.CLOSED_CODE
, 'OPEN') NOT IN ('CLOSED'
, 'FINALLY CLOSED')
AND POH.TYPE_LOOKUP_CODE = 'PLANNED'
AND POH.APPROVED_DATE IS NOT NULL
AND PLL.PO_HEADER_ID = POH.PO_HEADER_ID
AND PLL.SHIPMENT_TYPE = 'SCHEDULED' GROUP BY POH.PO_HEADER_ID
, POH.ORG_ID

Columns