Product: | XTR - Treasury |
---|---|
Description: | |
Implementation/DBA Data: | APPS.XTR_HEDGE_POLICIES_V |
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