[Home] [Help]
| Product: | PO - Purchasing |
|---|---|
| Description: | This view is used as the base view for the Price Differentials form. |
| Implementation/DBA Data: |
APPS.PO_PRICE_DIFFERENTIALS_V
|
SELECT PD.ROWID
, PD.PRICE_DIFFERENTIAL_ID
, PD.PRICE_DIFFERENTIAL_NUM
, PD.ENTITY_TYPE
, PD.ENTITY_ID
, PD.PRICE_TYPE
, PDLK.PRICE_DIFFERENTIAL_DSP
, PDLK.PRICE_DIFFERENTIAL_DESC
, PD.MULTIPLIER
, PD.MIN_MULTIPLIER
, PD.MAX_MULTIPLIER
, PD.ENABLED_FLAG
, PD.CREATED_BY
, PD.CREATION_DATE
, PD.LAST_UPDATED_BY
, PD.LAST_UPDATE_DATE
, PD.LAST_UPDATE_LOGIN
FROM PO_PRICE_DIFFERENTIALS PD
, PO_PRICE_DIFF_LOOKUPS_V PDLK
WHERE PD.PRICE_TYPE = PDLK.PRICE_DIFFERENTIAL_TYPE