[Home] [Help]
View: BIM_FCTV_ORDER_OFFERS
Product: | BIM - Marketing Intelligence(Obsolete) |
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
Name |
ORDER_HEADER_ID |
ORDER_LINE_ID |
OFFER_ID |
HEADER_OFFER_FLAG |