DBA Data[Home] [Help]

VIEW: APPS.PO_PRICE_DIFFERENTIALS_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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