FND Design Data [Home] [Help]

View: PO_ALERT_CONTRACT_VIEW2

Product: PO - Purchasing
Description: Contract purchase order total amount
Implementation/DBA Data: ViewAPPS.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

Name
PO_HEADER_ID
TOTAL_AMOUNT
ORG_ID