Product: | OE - Order Entry |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | Not implemented in this database |
SELECT PRICELIST.PRICE_LIST_ID
, PRICELIST.NAME
, PRICELIST.DESCRIPTION
, LOOKUP.MEANING
, PRICELIST.ROUNDING_FACTOR
, PRICELIST.COMMENTS
, PRICELIST.START_DATE_ACTIVE
, PRICELIST.END_DATE_ACTIVE
, '_DF:OE:SO_PRICE_LISTS:PRICELIST'
, PRICELIST2.NAME
, SHIP_METHOD.DESCRIPTION
, PAYTERM.NAME
, PRICELIST.SECONDARY_PRICE_LIST_ID
, PRICELIST.SHIP_METHOD_CODE
, PRICELIST.TERMS_ID
, PRICELIST.LAST_UPDATE_DATE
, PRICELIST.LAST_UPDATED_BY
, PRICELIST.CREATION_DATE
, PRICELIST.CREATED_BY
FROM SO_PRICE_LISTS PRICELIST
, SO_PRICE_LISTS PRICELIST2
, ORG_FREIGHT SHIP_METHOD
, RA_TERMS PAYTERM
, SO_LOOKUPS LOOKUP
WHERE PRICELIST.SECONDARY_PRICE_LIST_ID = PRICELIST2.PRICE_LIST_ID(+)
AND PRICELIST.SHIP_METHOD_CODE = SHIP_METHOD.FREIGHT_CODE(+)
AND PRICELIST.TERMS_ID = PAYTERM.TERM_ID(+)
AND LOOKUP.LOOKUP_TYPE(+) = 'FREIGHT_TERMS'
AND LOOKUP.LOOKUP_CODE(+) = PRICELIST.FREIGHT_TERMS_CODE WITH READ ONLY