View: BIM_FCTV_ORDER_OFFERS

Product:	BIM - Marketing Intelligence
Description:	Used by the concurrent programs to load the summary tables.
Implementation/DBA Data:	APPS.BIM_FCTV_ORDER_OFFERS

View Text

SELECT NVL(ODL.HEADER_ID
, -999) ORDER_HEADER_ID
, NVL(ODL.LINE_ID
, -999) ORDER_LINE_ID
, NVL(OFFR.ACTIVITY_OFFER_ID
, -999) OFFER_ID
, DECODE(ADJ.LINE_ID
, ''
, 'Y'
, 'N' ) HEADER_OFFER_FLAG
FROM ASO_I_ORDER_LINES_V ODL
, ASO_I_ORDER_PRICE_ADJS_V ADJ
, AMS_ACT_OFFERS OFFR
WHERE ODL.HEADER_ID = ADJ.HEADER_ID
AND OFFR.QP_LIST_HEADER_ID = ADJ.LIST_HEADER_ID
AND ADJ.APPLIED_FLAG = 'Y'
AND ODL.LINE_ID = NVL(ADJ.LINE_ID
, ODL.LINE_ID) WITH READ ONLY

Columns