eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.BIM_FCTV_ORDER_OFFERS

Source

View Text - Preformatted


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

View Text - HTML Formatted

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