VIEW: APPS.IEX_DUNNINGS_ACCT_BALI_V

Source

View Text - Preformatted

SELECT dun.dunning_id dunning_id, dun.status status, dun.creation_date creation_date, fm.template_name template_name, iex_trx_view_pkg.get_party_id(dun.dunning_object_id) party_cust_id, dun.dunning_object_id account_id, dun.dunning_method dunning_method, dun.amount_due_remaining amount_due_remaining, dun.currency_code currency_code, dun.object_id object_id, dun.object_type object_type, dun.dunning_object_id dunning_object_id, dun.dunning_level dunning_level, dun.ffm_request_id ffm_request_id, ffm.outcome_code ffm_status FROM iex_dunnings dun, jtf_fm_template fm, jtf_fm_request_history ffm WHERE fm.template_id (+) = dun.template_id AND dun.dunning_level = 'ACCOUNT' AND ffm.hist_req_id (+)= dun.ffm_request_id AND NVL(to_char(ffm.submit_dt_tm,'yymmddhhmi'),'x') = NVL( to_char(( select max(ffmb.submit_dt_tm) from jtf_Fm_request_history ffmb where ffmb.hist_req_id = dun.ffm_request_id), 'yymmddhhmi'), 'x')

View Text - HTML Formatted

SELECT DUN.DUNNING_ID DUNNING_ID
, DUN.STATUS STATUS
, DUN.CREATION_DATE CREATION_DATE
, FM.TEMPLATE_NAME TEMPLATE_NAME
, IEX_TRX_VIEW_PKG.GET_PARTY_ID(DUN.DUNNING_OBJECT_ID) PARTY_CUST_ID
, DUN.DUNNING_OBJECT_ID ACCOUNT_ID
, DUN.DUNNING_METHOD DUNNING_METHOD
, DUN.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING
, DUN.CURRENCY_CODE CURRENCY_CODE
, DUN.OBJECT_ID OBJECT_ID
, DUN.OBJECT_TYPE OBJECT_TYPE
, DUN.DUNNING_OBJECT_ID DUNNING_OBJECT_ID
, DUN.DUNNING_LEVEL DUNNING_LEVEL
, DUN.FFM_REQUEST_ID FFM_REQUEST_ID
, FFM.OUTCOME_CODE FFM_STATUS
FROM IEX_DUNNINGS DUN
, JTF_FM_TEMPLATE FM
, JTF_FM_REQUEST_HISTORY FFM
WHERE FM.TEMPLATE_ID (+) = DUN.TEMPLATE_ID
AND DUN.DUNNING_LEVEL = 'ACCOUNT'
AND FFM.HIST_REQ_ID (+)= DUN.FFM_REQUEST_ID
AND NVL(TO_CHAR(FFM.SUBMIT_DT_TM
, 'YYMMDDHHMI')
, 'X') = NVL( TO_CHAR(( SELECT MAX(FFMB.SUBMIT_DT_TM)
FROM JTF_FM_REQUEST_HISTORY FFMB
WHERE FFMB.HIST_REQ_ID = DUN.FFM_REQUEST_ID)
, 'YYMMDDHHMI')
, 'X')