eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IEX_STRATEGIES_BALI_V

Source

View Text - Preformatted


SELECT strat.strategy_id STRATEGY_ID, strat.strategy_template_id STRATEGY_TEMPLATE_ID, strat_temp.strategy_name STRATEGY_NAME, lkp.meaning CATEGORY_TYPE_MEANING, strat_temp.category_type CATEGORY, strat_temp.strategy_rank RANK, strat.status_code STATUS, lookup.meaning STATUS_MEANING, strat_temp.valid_from_dt VALID_FROM, strat_temp.valid_to_dt VALID_TO, strat.score_value STRATEGY_SCORE, strat.user_work_item_yn RESCORE_YN, strat.Delinquency_id DELINQUENCY_ID, cust.account_number ACCOUNT_NUMBER, ar.amount_due_remaining OVERDUE_AMT, strat.cust_Account_id CUST_ACCOUNT_ID, strat.party_id PARTY_ID, strat.object_type OBJECT_TYPE, strat.object_id OBJECT_ID, strat.created_by CREATED_BY, strat.creation_date CREATION_DATE, strat.last_updated_by LAST_UPDATED_BY, strat.last_update_date LAST_UPDATE_DATE, del.transaction_id TRX_ID, trx.trx_number TRX_NUMBER, cobj.cas_id CASE_ID, cobj.cas_id CASE_NUMBER, strat.jtf_object_type JTF_OBJECT_TYPE, JOB.NAME JTF_OBJECT_NAME, strat.jtf_object_id JTF_OBJECT_ID, strat.strategy_level STRATEGY_LEVEL, decode(strat.strategy_level, 10, 'Customer', 20, 'Account', 30, 'Bill To', 'Delinquency') STRATEGY_LEVEL_CODE, STRAT.SCORE_VALUE SCORE, strat.customer_site_use_id, su_bill.location, su_bill.address, h.party_name, strat.org_id, hu.name operating_unit, 'N' archived_code, iex_utilities.get_lookup_meaning('IEX_YES_NO','N') archived, strat.hold_start_date hold_start_date, strat.release_date release_date from iex_strategies strat, iex_strategy_templates_vl strat_temp, iex_lookups_v lookup, iex_lookups_v lkp, hz_cust_accounts cust, iex_delinquencies del, ar_payment_schedules ar, ra_customer_trx_all trx, JTF_OBJECTS_VL JOB, iex_cust_site_uses_v su_bill, hz_parties h , iex_case_objects cobj , okl_cnsld_ar_strms_b lsm, hr_operating_units hu WHERE strat.strategy_template_id = strat_temp.strategy_temp_id and strat.status_code = lookup.lookup_code and lookup.lookup_type = 'IEX_STRATEGY_STATUS' and lkp.lookup_type = 'IEX_DELINQUENCY_STATUS' and lkp.enabled_flag = 'Y' and strat_temp.category_type = lkp.lookup_code and strat.delinquency_id = del.delinquency_id(+) and (strat.checklist_yn is null or strat.checklist_yn <> 'Y') and strat.party_id = cust.party_id(+) and strat.party_id = h.party_id(+) and strat.cust_account_id = cust.cust_account_id(+) and strat.customer_site_use_id = su_bill.customer_site_use_id(+) and del.payment_schedule_id = ar.payment_schedule_id(+) and del.transaction_id = trx.customer_trx_id(+) and del.transaction_id =lsm.receivables_invoice_id(+) and lsm.khr_id =cobj.object_id(+) and strat.jtf_object_type = JOB.object_code(+) and strat.org_id = hu.organization_id(+) UNION ALL SELECT strat.strategy_id STRATEGY_ID, strat.strategy_template_id STRATEGY_TEMPLATE_ID, strat_temp.strategy_name STRATEGY_NAME, lkp.meaning CATEGORY_TYPE_MEANING, strat_temp.category_type CATEGORY, strat_temp.strategy_rank RANK, strat.status_code STATUS, lookup.meaning STATUS_MEANING, strat_temp.valid_from_dt VALID_FROM, strat_temp.valid_to_dt VALID_TO, strat.score_value STRATEGY_SCORE, strat.user_work_item_yn RESCORE_YN, strat.Delinquency_id DELINQUENCY_ID, cust.account_number ACCOUNT_NUMBER, ar.amount_due_remaining OVERDUE_AMT, strat.cust_Account_id CUST_ACCOUNT_ID, strat.party_id PARTY_ID, strat.object_type OBJECT_TYPE, strat.object_id OBJECT_ID, strat.created_by CREATED_BY, strat.creation_date CREATION_DATE, strat.last_updated_by LAST_UPDATED_BY, strat.last_update_date LAST_UPDATE_DATE, del.transaction_id TRX_ID, trx.trx_number TRX_NUMBER, cobj.cas_id CASE_ID, cobj.cas_id CASE_NUMBER, strat.jtf_object_type JTF_OBJECT_TYPE, JOB.NAME JTF_OBJECT_NAME, strat.jtf_object_id JTF_OBJECT_ID, strat.strategy_level STRATEGY_LEVEL, DECODE(strat.strategy_level, 10, 'Customer', 20, 'Account', 30, 'Bill To', 'Delinquency') STRATEGY_LEVEL_CODE, STRAT.SCORE_VALUE SCORE, strat.customer_site_use_id, su_bill.location, su_bill.address, h.party_name, strat.org_id, hu.name operating_unit, 'Y' archived_code, iex_utilities.get_lookup_meaning('IEX_YES_NO','Y') archived, NULL hold_start_date, NULL release_date FROM iex_strategies_history strat, iex_strategy_templates_vl strat_temp, iex_lookups_v lookup, iex_lookups_v lkp, hz_cust_accounts cust, iex_delinquencies del, ar_payment_schedules ar, ra_customer_trx_all trx, JTF_OBJECTS_VL JOB, iex_cust_site_uses_v su_bill, hz_parties h , iex_case_objects cobj , okl_cnsld_ar_strms_b lsm, hr_operating_units hu WHERE strat.strategy_template_id = strat_temp.strategy_temp_id AND strat.status_code = lookup.lookup_code AND lookup.lookup_type = 'IEX_STRATEGY_STATUS' AND lkp.lookup_type = 'IEX_DELINQUENCY_STATUS' AND lkp.enabled_flag = 'Y' AND strat_temp.category_type = lkp.lookup_code AND strat.delinquency_id = del.delinquency_id(+) AND (strat.checklist_yn IS NULL OR strat.checklist_yn <> 'Y') AND strat.party_id = cust.party_id(+) AND strat.party_id = h.party_id(+) AND strat.cust_account_id = cust.cust_account_id(+) AND strat.customer_site_use_id = su_bill.customer_site_use_id(+) AND del.payment_schedule_id = ar.payment_schedule_id(+) AND del.transaction_id = trx.customer_trx_id(+) AND del.transaction_id =lsm.receivables_invoice_id(+) AND lsm.khr_id =cobj.object_id(+) AND strat.jtf_object_type = JOB.object_code(+) AND strat.org_id = hu.organization_id(+)

View Text - HTML Formatted

SELECT STRAT.STRATEGY_ID STRATEGY_ID
, STRAT.STRATEGY_TEMPLATE_ID STRATEGY_TEMPLATE_ID
, STRAT_TEMP.STRATEGY_NAME STRATEGY_NAME
, LKP.MEANING CATEGORY_TYPE_MEANING
, STRAT_TEMP.CATEGORY_TYPE CATEGORY
, STRAT_TEMP.STRATEGY_RANK RANK
, STRAT.STATUS_CODE STATUS
, LOOKUP.MEANING STATUS_MEANING
, STRAT_TEMP.VALID_FROM_DT VALID_FROM
, STRAT_TEMP.VALID_TO_DT VALID_TO
, STRAT.SCORE_VALUE STRATEGY_SCORE
, STRAT.USER_WORK_ITEM_YN RESCORE_YN
, STRAT.DELINQUENCY_ID DELINQUENCY_ID
, CUST.ACCOUNT_NUMBER ACCOUNT_NUMBER
, AR.AMOUNT_DUE_REMAINING OVERDUE_AMT
, STRAT.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, STRAT.PARTY_ID PARTY_ID
, STRAT.OBJECT_TYPE OBJECT_TYPE
, STRAT.OBJECT_ID OBJECT_ID
, STRAT.CREATED_BY CREATED_BY
, STRAT.CREATION_DATE CREATION_DATE
, STRAT.LAST_UPDATED_BY LAST_UPDATED_BY
, STRAT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DEL.TRANSACTION_ID TRX_ID
, TRX.TRX_NUMBER TRX_NUMBER
, COBJ.CAS_ID CASE_ID
, COBJ.CAS_ID CASE_NUMBER
, STRAT.JTF_OBJECT_TYPE JTF_OBJECT_TYPE
, JOB.NAME JTF_OBJECT_NAME
, STRAT.JTF_OBJECT_ID JTF_OBJECT_ID
, STRAT.STRATEGY_LEVEL STRATEGY_LEVEL
, DECODE(STRAT.STRATEGY_LEVEL
, 10
, 'CUSTOMER'
, 20
, 'ACCOUNT'
, 30
, 'BILL TO'
, 'DELINQUENCY') STRATEGY_LEVEL_CODE
, STRAT.SCORE_VALUE SCORE
, STRAT.CUSTOMER_SITE_USE_ID
, SU_BILL.LOCATION
, SU_BILL.ADDRESS
, H.PARTY_NAME
, STRAT.ORG_ID
, HU.NAME OPERATING_UNIT
, 'N' ARCHIVED_CODE
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_YES_NO'
, 'N') ARCHIVED
, STRAT.HOLD_START_DATE HOLD_START_DATE
, STRAT.RELEASE_DATE RELEASE_DATE
FROM IEX_STRATEGIES STRAT
, IEX_STRATEGY_TEMPLATES_VL STRAT_TEMP
, IEX_LOOKUPS_V LOOKUP
, IEX_LOOKUPS_V LKP
, HZ_CUST_ACCOUNTS CUST
, IEX_DELINQUENCIES DEL
, AR_PAYMENT_SCHEDULES AR
, RA_CUSTOMER_TRX_ALL TRX
, JTF_OBJECTS_VL JOB
, IEX_CUST_SITE_USES_V SU_BILL
, HZ_PARTIES H
, IEX_CASE_OBJECTS COBJ
, OKL_CNSLD_AR_STRMS_B LSM
, HR_OPERATING_UNITS HU
WHERE STRAT.STRATEGY_TEMPLATE_ID = STRAT_TEMP.STRATEGY_TEMP_ID
AND STRAT.STATUS_CODE = LOOKUP.LOOKUP_CODE
AND LOOKUP.LOOKUP_TYPE = 'IEX_STRATEGY_STATUS'
AND LKP.LOOKUP_TYPE = 'IEX_DELINQUENCY_STATUS'
AND LKP.ENABLED_FLAG = 'Y'
AND STRAT_TEMP.CATEGORY_TYPE = LKP.LOOKUP_CODE
AND STRAT.DELINQUENCY_ID = DEL.DELINQUENCY_ID(+)
AND (STRAT.CHECKLIST_YN IS NULL OR STRAT.CHECKLIST_YN <> 'Y')
AND STRAT.PARTY_ID = CUST.PARTY_ID(+)
AND STRAT.PARTY_ID = H.PARTY_ID(+)
AND STRAT.CUST_ACCOUNT_ID = CUST.CUST_ACCOUNT_ID(+)
AND STRAT.CUSTOMER_SITE_USE_ID = SU_BILL.CUSTOMER_SITE_USE_ID(+)
AND DEL.PAYMENT_SCHEDULE_ID = AR.PAYMENT_SCHEDULE_ID(+)
AND DEL.TRANSACTION_ID = TRX.CUSTOMER_TRX_ID(+)
AND DEL.TRANSACTION_ID =LSM.RECEIVABLES_INVOICE_ID(+)
AND LSM.KHR_ID =COBJ.OBJECT_ID(+)
AND STRAT.JTF_OBJECT_TYPE = JOB.OBJECT_CODE(+)
AND STRAT.ORG_ID = HU.ORGANIZATION_ID(+) UNION ALL SELECT STRAT.STRATEGY_ID STRATEGY_ID
, STRAT.STRATEGY_TEMPLATE_ID STRATEGY_TEMPLATE_ID
, STRAT_TEMP.STRATEGY_NAME STRATEGY_NAME
, LKP.MEANING CATEGORY_TYPE_MEANING
, STRAT_TEMP.CATEGORY_TYPE CATEGORY
, STRAT_TEMP.STRATEGY_RANK RANK
, STRAT.STATUS_CODE STATUS
, LOOKUP.MEANING STATUS_MEANING
, STRAT_TEMP.VALID_FROM_DT VALID_FROM
, STRAT_TEMP.VALID_TO_DT VALID_TO
, STRAT.SCORE_VALUE STRATEGY_SCORE
, STRAT.USER_WORK_ITEM_YN RESCORE_YN
, STRAT.DELINQUENCY_ID DELINQUENCY_ID
, CUST.ACCOUNT_NUMBER ACCOUNT_NUMBER
, AR.AMOUNT_DUE_REMAINING OVERDUE_AMT
, STRAT.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, STRAT.PARTY_ID PARTY_ID
, STRAT.OBJECT_TYPE OBJECT_TYPE
, STRAT.OBJECT_ID OBJECT_ID
, STRAT.CREATED_BY CREATED_BY
, STRAT.CREATION_DATE CREATION_DATE
, STRAT.LAST_UPDATED_BY LAST_UPDATED_BY
, STRAT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DEL.TRANSACTION_ID TRX_ID
, TRX.TRX_NUMBER TRX_NUMBER
, COBJ.CAS_ID CASE_ID
, COBJ.CAS_ID CASE_NUMBER
, STRAT.JTF_OBJECT_TYPE JTF_OBJECT_TYPE
, JOB.NAME JTF_OBJECT_NAME
, STRAT.JTF_OBJECT_ID JTF_OBJECT_ID
, STRAT.STRATEGY_LEVEL STRATEGY_LEVEL
, DECODE(STRAT.STRATEGY_LEVEL
, 10
, 'CUSTOMER'
, 20
, 'ACCOUNT'
, 30
, 'BILL TO'
, 'DELINQUENCY') STRATEGY_LEVEL_CODE
, STRAT.SCORE_VALUE SCORE
, STRAT.CUSTOMER_SITE_USE_ID
, SU_BILL.LOCATION
, SU_BILL.ADDRESS
, H.PARTY_NAME
, STRAT.ORG_ID
, HU.NAME OPERATING_UNIT
, 'Y' ARCHIVED_CODE
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_YES_NO'
, 'Y') ARCHIVED
, NULL HOLD_START_DATE
, NULL RELEASE_DATE
FROM IEX_STRATEGIES_HISTORY STRAT
, IEX_STRATEGY_TEMPLATES_VL STRAT_TEMP
, IEX_LOOKUPS_V LOOKUP
, IEX_LOOKUPS_V LKP
, HZ_CUST_ACCOUNTS CUST
, IEX_DELINQUENCIES DEL
, AR_PAYMENT_SCHEDULES AR
, RA_CUSTOMER_TRX_ALL TRX
, JTF_OBJECTS_VL JOB
, IEX_CUST_SITE_USES_V SU_BILL
, HZ_PARTIES H
, IEX_CASE_OBJECTS COBJ
, OKL_CNSLD_AR_STRMS_B LSM
, HR_OPERATING_UNITS HU
WHERE STRAT.STRATEGY_TEMPLATE_ID = STRAT_TEMP.STRATEGY_TEMP_ID
AND STRAT.STATUS_CODE = LOOKUP.LOOKUP_CODE
AND LOOKUP.LOOKUP_TYPE = 'IEX_STRATEGY_STATUS'
AND LKP.LOOKUP_TYPE = 'IEX_DELINQUENCY_STATUS'
AND LKP.ENABLED_FLAG = 'Y'
AND STRAT_TEMP.CATEGORY_TYPE = LKP.LOOKUP_CODE
AND STRAT.DELINQUENCY_ID = DEL.DELINQUENCY_ID(+)
AND (STRAT.CHECKLIST_YN IS NULL OR STRAT.CHECKLIST_YN <> 'Y')
AND STRAT.PARTY_ID = CUST.PARTY_ID(+)
AND STRAT.PARTY_ID = H.PARTY_ID(+)
AND STRAT.CUST_ACCOUNT_ID = CUST.CUST_ACCOUNT_ID(+)
AND STRAT.CUSTOMER_SITE_USE_ID = SU_BILL.CUSTOMER_SITE_USE_ID(+)
AND DEL.PAYMENT_SCHEDULE_ID = AR.PAYMENT_SCHEDULE_ID(+)
AND DEL.TRANSACTION_ID = TRX.CUSTOMER_TRX_ID(+)
AND DEL.TRANSACTION_ID =LSM.RECEIVABLES_INVOICE_ID(+)
AND LSM.KHR_ID =COBJ.OBJECT_ID(+)
AND STRAT.JTF_OBJECT_TYPE = JOB.OBJECT_CODE(+)
AND STRAT.ORG_ID = HU.ORGANIZATION_ID(+)