VIEW: APPS.XTR_IRS_ACTUALS_V

Source

View Text - Preformatted

SELECT UNIQUE_REF_NUMBER ,COMPANY_CODE ,CURRENCY ,PORTFOLIO_CODE ,INC_IG ,AMOUNT_UNIT ,FUND_INVEST ,FROM_DATE ,TO_DATE ,COMPANY_NAME ,PORT_NAME ,FLOATING_LESS ,PF_AMT ,PX_AMT ,PT_AMT ,PF_DAYS ,PX_DAYS ,PT_DAYS ,PFW_AMT ,PXW_AMT ,PTW_AMT ,SF_AMT ,SX_AMT ,ST_AMT ,STW_AMT ,ST_DAYS ,PFA_AMT ,PXA_AMT ,PTA_AMT ,SA_AMT ,PFA_DAYS ,PXA_DAYS ,PTA_DAYS ,SA_DAYS ,PF_COVER ,PX_COVER ,PT_COVER ,ACTUAL_FIXED ,S_COVER ,POLICY_MAX ,POLICY_MIN ,DAY_ADJUST ,VARIANCE_MIN ,MIN_WAMT ,VARIANCE_MAX ,MAX_WAMT ,MAX_AMT ,MIN_AMT ,CREATED_ON ,CREATED_BY from XTR_IRS_ACTUALS

View Text - HTML Formatted

SELECT UNIQUE_REF_NUMBER
, COMPANY_CODE
, CURRENCY
, PORTFOLIO_CODE
, INC_IG
, AMOUNT_UNIT
, FUND_INVEST
, FROM_DATE
, TO_DATE
, COMPANY_NAME
, PORT_NAME
, FLOATING_LESS
, PF_AMT
, PX_AMT
, PT_AMT
, PF_DAYS
, PX_DAYS
, PT_DAYS
, PFW_AMT
, PXW_AMT
, PTW_AMT
, SF_AMT
, SX_AMT
, ST_AMT
, STW_AMT
, ST_DAYS
, PFA_AMT
, PXA_AMT
, PTA_AMT
, SA_AMT
, PFA_DAYS
, PXA_DAYS
, PTA_DAYS
, SA_DAYS
, PF_COVER
, PX_COVER
, PT_COVER
, ACTUAL_FIXED
, S_COVER
, POLICY_MAX
, POLICY_MIN
, DAY_ADJUST
, VARIANCE_MIN
, MIN_WAMT
, VARIANCE_MAX
, MAX_WAMT
, MAX_AMT
, MIN_AMT
, CREATED_ON
, CREATED_BY
FROM XTR_IRS_ACTUALS