VIEW: APPS.XTR_HEDGE_POLICIES_V

Source

View Text - Preformatted

SELECT HP.ROWID ,HP.HEDGE_POLICY_ID ,HP.SOURCE_TYPE_ID ,ST.SOURCE_CODE ,FL1.MEANING SOURCE_NAME ,ST.SUB_SOURCE_CODE ,FL2.MEANING SUB_SOURCE_NAME ,ST.INSTRUMENT_ITEM_CATEGORY ,FL.MEANING ,ST.INSTRUMENT_ITEM_FLAG ,HP.CASHFLOW_FLAG ,HP.FAIRVALUE_FLAG ,HP.ECONOMIC_FLAG ,HP.CREATED_BY ,HP.CREATION_DATE ,HP.LAST_UPDATED_BY ,HP.LAST_UPDATE_DATE ,HP.LAST_UPDATE_LOGIN FROM XTR_HEDGE_POLICIES HP,XTR_SOURCE_TYPES ST,FND_LOOKUPS FL,FND_LOOKUPS FL1,FND_LOOKUPS FL2 WHERE HP.SOURCE_TYPE_ID = ST.SOURCE_TYPE_ID AND ST.INSTRUMENT_ITEM_CATEGORY = FL.LOOKUP_CODE AND FL.LOOKUP_TYPE = DECODE(ST.INSTRUMENT_ITEM_FLAG,'U','XTR_HEDGE_INSTRUMENT_CATEGORY','I','XTR_HEDGE_ITEM_CATEGORY') AND FL1.LOOKUP_TYPE = 'XTR_HEDGE_SOURCES' AND ST.SOURCE_CODE = FL1.LOOKUP_CODE AND ST.SOURCE_CODE <> 'XTR' AND decode(ST.SOURCE_CODE,'AR','XTR_HEDGE_SUB_SOURCES_AR','AP','XTR_HEDGE_SUB_SOURCES_AP','XTR_HEDGE_SOURCES') = FL2.LOOKUP_TYPE AND NVL(ST.SUB_SOURCE_CODE, ST.SOURCE_CODE) = FL2.LOOKUP_CODE UNION ALL SELECT HP.ROWID ,HP.HEDGE_POLICY_ID ,HP.SOURCE_TYPE_ID ,ST.SOURCE_CODE ,FL1.MEANING SOURCE_NAME ,ST.SUB_SOURCE_CODE ,DT.USER_DEAL_TYPE SUB_SOURCE_NAME ,ST.INSTRUMENT_ITEM_CATEGORY ,FL.MEANING ,ST.INSTRUMENT_ITEM_FLAG ,HP.CASHFLOW_FLAG ,HP.FAIRVALUE_FLAG ,HP.ECONOMIC_FLAG ,HP.CREATED_BY ,HP.CREATION_DATE ,HP.LAST_UPDATED_BY ,HP.LAST_UPDATE_DATE ,HP.LAST_UPDATE_LOGIN FROM XTR_HEDGE_POLICIES HP,XTR_SOURCE_TYPES ST,FND_LOOKUPS FL,FND_LOOKUPS FL1,XTR_DEAL_TYPES DT WHERE HP.SOURCE_TYPE_ID = ST.SOURCE_TYPE_ID AND ST.INSTRUMENT_ITEM_CATEGORY = FL.LOOKUP_CODE AND FL.LOOKUP_TYPE = DECODE(ST.INSTRUMENT_ITEM_FLAG,'U','XTR_HEDGE_INSTRUMENT_CATEGORY','I','XTR_HEDGE_ITEM_CATEGORY') AND FL1.LOOKUP_TYPE = 'XTR_HEDGE_SOURCES' AND ST.SOURCE_CODE = FL1.LOOKUP_CODE AND ST.SOURCE_CODE = 'XTR' AND ST.SUB_SOURCE_CODE = DT.DEAL_TYPE

View Text - HTML Formatted

SELECT HP.ROWID
, HP.HEDGE_POLICY_ID
, HP.SOURCE_TYPE_ID
, ST.SOURCE_CODE
, FL1.MEANING SOURCE_NAME
, ST.SUB_SOURCE_CODE
, FL2.MEANING SUB_SOURCE_NAME
, ST.INSTRUMENT_ITEM_CATEGORY
, FL.MEANING
, ST.INSTRUMENT_ITEM_FLAG
, HP.CASHFLOW_FLAG
, HP.FAIRVALUE_FLAG
, HP.ECONOMIC_FLAG
, HP.CREATED_BY
, HP.CREATION_DATE
, HP.LAST_UPDATED_BY
, HP.LAST_UPDATE_DATE
, HP.LAST_UPDATE_LOGIN
FROM XTR_HEDGE_POLICIES HP
, XTR_SOURCE_TYPES ST
, FND_LOOKUPS FL
, FND_LOOKUPS FL1
, FND_LOOKUPS FL2
WHERE HP.SOURCE_TYPE_ID = ST.SOURCE_TYPE_ID
AND ST.INSTRUMENT_ITEM_CATEGORY = FL.LOOKUP_CODE
AND FL.LOOKUP_TYPE = DECODE(ST.INSTRUMENT_ITEM_FLAG
, 'U'
, 'XTR_HEDGE_INSTRUMENT_CATEGORY'
, 'I'
, 'XTR_HEDGE_ITEM_CATEGORY')
AND FL1.LOOKUP_TYPE = 'XTR_HEDGE_SOURCES'
AND ST.SOURCE_CODE = FL1.LOOKUP_CODE
AND ST.SOURCE_CODE <> 'XTR'
AND DECODE(ST.SOURCE_CODE
, 'AR'
, 'XTR_HEDGE_SUB_SOURCES_AR'
, 'AP'
, 'XTR_HEDGE_SUB_SOURCES_AP'
, 'XTR_HEDGE_SOURCES') = FL2.LOOKUP_TYPE
AND NVL(ST.SUB_SOURCE_CODE
, ST.SOURCE_CODE) = FL2.LOOKUP_CODE UNION ALL SELECT HP.ROWID
, HP.HEDGE_POLICY_ID
, HP.SOURCE_TYPE_ID
, ST.SOURCE_CODE
, FL1.MEANING SOURCE_NAME
, ST.SUB_SOURCE_CODE
, DT.USER_DEAL_TYPE SUB_SOURCE_NAME
, ST.INSTRUMENT_ITEM_CATEGORY
, FL.MEANING
, ST.INSTRUMENT_ITEM_FLAG
, HP.CASHFLOW_FLAG
, HP.FAIRVALUE_FLAG
, HP.ECONOMIC_FLAG
, HP.CREATED_BY
, HP.CREATION_DATE
, HP.LAST_UPDATED_BY
, HP.LAST_UPDATE_DATE
, HP.LAST_UPDATE_LOGIN
FROM XTR_HEDGE_POLICIES HP
, XTR_SOURCE_TYPES ST
, FND_LOOKUPS FL
, FND_LOOKUPS FL1
, XTR_DEAL_TYPES DT
WHERE HP.SOURCE_TYPE_ID = ST.SOURCE_TYPE_ID
AND ST.INSTRUMENT_ITEM_CATEGORY = FL.LOOKUP_CODE
AND FL.LOOKUP_TYPE = DECODE(ST.INSTRUMENT_ITEM_FLAG
, 'U'
, 'XTR_HEDGE_INSTRUMENT_CATEGORY'
, 'I'
, 'XTR_HEDGE_ITEM_CATEGORY')
AND FL1.LOOKUP_TYPE = 'XTR_HEDGE_SOURCES'
AND ST.SOURCE_CODE = FL1.LOOKUP_CODE
AND ST.SOURCE_CODE = 'XTR'
AND ST.SUB_SOURCE_CODE = DT.DEAL_TYPE