[Home] [Help]
View: PO_PRICE_DIFFERENTIALS_V
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
|
View Text
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
Columns
Name |
ROW_ID |
PRICE_DIFFERENTIAL_ID |
PRICE_DIFFERENTIAL_NUM |
ENTITY_TYPE |
ENTITY_ID |
PRICE_TYPE |
PRICE_TYPE_DSP |
DESCRIPTION |
MULTIPLIER |
MIN_MULTIPLIER |
MAX_MULTIPLIER |
ENABLED_FLAG |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |