VIEW: APPS.XTR_DISC_ACCRLS_AMORT_V

Source

View Text - Preformatted

SELECT ac.DEAL_NO, ac.BATCH_ID, ac.TRANS_NO, ac.PERIOD_FROM, ac.PERIOD_TO, ac.COMPANY_CODE, dt.USER_DEAL_TYPE, st.USER_DEAL_SUBTYPE, ac.CPARTY_CODE, ac.CURRENCY, ac.PRODUCT_TYPE, ac.PORTFOLIO_CODE, ac.AMOUNT_TYPE, ac.ACTION_CODE, ac.TRANSACTION_AMOUNT, ac.ACTUAL_START_DATE, ac.ACTUAL_MATURITY_DATE, ac.INTEREST_RATE, ac.NO_OF_DAYS, ac.YEAR_BASIS, ac.ACCRLS_AMOUNT, ac.FIRST_ACCRUAL_INDIC, ac.ACCRLS_AMOUNT_BAL, ac.EFFECTIVE_CALCULATED_VALUE, ac.CALC_FACE_VALUE, ac.EFFINT_ACCRLS_AMOUNT_BAL, pi1.FULL_NAME COMPANY_NAME, dt.NAME DEAL_TYPE_NAME, st.NAME DEAL_SUBTYPE_NAME, pi2.FULL_NAME CPARTY_NAME, p.PRODUCT_DESC PRODUCT_TYPE_DESC FROM XTR_ACCRLS_AMORT ac, XTR_DEAL_TYPES dt, XTR_DEAL_SUBTYPES st, XTR_COMPANY_AUTHORITIES xca, XTR_DEALER_CODES xdc, XTR_PRODUCT_TYPES p, XTR_PARTY_INFO pi1, XTR_PARTY_INFO pi2 WHERE dt.DEAL_TYPE = ac.DEAL_TYPE and (st.DEAL_TYPE = ac.DEAL_TYPE and st.DEAL_SUBTYPE = ac.DEAL_SUBTYPE) AND (P.DEAL_TYPE(+) = ac.DEAL_TYPE and P.PRODUCT_TYPE(+) = ac.PRODUCT_TYPE) AND pi1.PARTY_CODE = ac.COMPANY_CODE AND pi2.PARTY_CODE(+) = ac.CPARTY_CODE AND ac.COMPANY_CODE=xca.PARTY_CODE AND xca.DEALER_CODE=xdc.DEALER_CODE AND xca.company_authorised_for_input = 'Y' AND xdc.USER_ID=fnd_global.user_id

View Text - HTML Formatted

SELECT AC.DEAL_NO
, AC.BATCH_ID
, AC.TRANS_NO
, AC.PERIOD_FROM
, AC.PERIOD_TO
, AC.COMPANY_CODE
, DT.USER_DEAL_TYPE
, ST.USER_DEAL_SUBTYPE
, AC.CPARTY_CODE
, AC.CURRENCY
, AC.PRODUCT_TYPE
, AC.PORTFOLIO_CODE
, AC.AMOUNT_TYPE
, AC.ACTION_CODE
, AC.TRANSACTION_AMOUNT
, AC.ACTUAL_START_DATE
, AC.ACTUAL_MATURITY_DATE
, AC.INTEREST_RATE
, AC.NO_OF_DAYS
, AC.YEAR_BASIS
, AC.ACCRLS_AMOUNT
, AC.FIRST_ACCRUAL_INDIC
, AC.ACCRLS_AMOUNT_BAL
, AC.EFFECTIVE_CALCULATED_VALUE
, AC.CALC_FACE_VALUE
, AC.EFFINT_ACCRLS_AMOUNT_BAL
, PI1.FULL_NAME COMPANY_NAME
, DT.NAME DEAL_TYPE_NAME
, ST.NAME DEAL_SUBTYPE_NAME
, PI2.FULL_NAME CPARTY_NAME
, P.PRODUCT_DESC PRODUCT_TYPE_DESC
FROM XTR_ACCRLS_AMORT AC
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST
, XTR_COMPANY_AUTHORITIES XCA
, XTR_DEALER_CODES XDC
, XTR_PRODUCT_TYPES P
, XTR_PARTY_INFO PI1
, XTR_PARTY_INFO PI2
WHERE DT.DEAL_TYPE = AC.DEAL_TYPE
AND (ST.DEAL_TYPE = AC.DEAL_TYPE
AND ST.DEAL_SUBTYPE = AC.DEAL_SUBTYPE)
AND (P.DEAL_TYPE(+) = AC.DEAL_TYPE
AND P.PRODUCT_TYPE(+) = AC.PRODUCT_TYPE)
AND PI1.PARTY_CODE = AC.COMPANY_CODE
AND PI2.PARTY_CODE(+) = AC.CPARTY_CODE
AND AC.COMPANY_CODE=XCA.PARTY_CODE
AND XCA.DEALER_CODE=XDC.DEALER_CODE
AND XCA.COMPANY_AUTHORISED_FOR_INPUT = 'Y'
AND XDC.USER_ID=FND_GLOBAL.USER_ID