FND Design Data [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: ViewAPPS.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