VIEW: APPS.IEX_DELINQUENCIES_UWQ_V

Source

View Text - Preformatted

SELECT objb.object_function ieu_object_function, objb.object_parameters || ' RETURNED_FROM=IEUSEUWQ MO_DEFAULT_ORG_ID=' || idel.org_id ieu_object_parameters, '' ieu_media_type_uuid, 'DELINQUENCY_ID' ieu_param_pk_col, to_char(idel.delinquency_id) ieu_param_pk_value, idel.delinquency_id delinquency_id, 1 resource_id, idel.party_cust_id customer_id, 'RS_EMPLOYEE' resource_type, ipar.party_name party_name, ipar.person_first_name first_name, ipar.person_last_name last_name, ipar.party_type party_type, idel.cust_account_id cust_account_id, iacc.account_number account_number, idel.customer_site_use_id site_use_id, idel.payment_schedule_id payment_schedule_id, to_number('') aging_bucket_line_id, '' bucket_name, idel.transaction_id transaction_id, ipay.amount_due_original amount_due_original, ipay.amount_due_remaining amount_due_remaining, ipay.trx_number transaction_number, ipay.invoice_currency_code invoice_currency_code, ipay.due_date due_date, ipay.gl_date gl_date, ipay.term_id term_id, ipay.terms_sequence_number terms_sequence_number, idel.autoassign_yn autoassign_yn, idel.status status, idel.campaign_sched_id campaign_sched_id, ams.source_code source_code, idel.org_id org_id, idel.creation_date creation_date, idel.created_by created_by, idel.last_update_date last_update_date, idel.last_updated_by last_updated_by, rs.source_name last_updated_byname, idel.uwq_status uwq_status, idel.uwq_active_date uwq_active_date, idel.uwq_complete_date uwq_complete_date, hu.name operating_unit_name FROM iex_delinquencies idel, ar_payment_schedules_all ipay, hr_operating_units hu, ams_source_codes ams, hz_cust_accounts iacc, hz_parties ipar, jtf_rs_resource_extns rs, jtf_objects_b objb WHERE idel.status IN('DELINQUENT', 'PREDELINQUENT') AND idel.payment_schedule_id = ipay.payment_schedule_id(+) AND idel.org_id = ipay.org_id AND idel.org_id = hu.organization_id AND ipay.status = 'OP' AND idel.cust_account_id = iacc.cust_account_id(+) AND idel.campaign_sched_id = ams.source_code_id(+) AND idel.party_cust_id = ipar.party_id AND objb.object_code = 'IEX_DELINQUENCY' AND idel.last_updated_by = rs.user_id(+) GROUP BY objb.object_function, objb.object_parameters, to_char(idel.delinquency_id), idel.delinquency_id, idel.party_cust_id, ipar.party_name, ipar.person_first_name, ipar.person_last_name, ipar.party_type, idel.cust_account_id, iacc.account_number, idel.customer_site_use_id, idel.payment_schedule_id, idel.transaction_id, ipay.amount_due_original, ipay.amount_due_remaining, ipay.trx_number, ipay.invoice_currency_code, ipay.due_date, ipay.gl_date, ipay.term_id, ipay.terms_sequence_number, idel.autoassign_yn, idel.status, idel.campaign_sched_id, ams.source_code, idel.creation_date, idel.created_by, idel.last_update_date, idel.last_updated_by, rs.source_name, idel.uwq_status, idel.uwq_active_date, idel.uwq_complete_date, idel.org_id, hu.name

View Text - HTML Formatted

SELECT OBJB.OBJECT_FUNCTION IEU_OBJECT_FUNCTION
, OBJB.OBJECT_PARAMETERS || ' RETURNED_FROM=IEUSEUWQ MO_DEFAULT_ORG_ID=' || IDEL.ORG_ID IEU_OBJECT_PARAMETERS
, '' IEU_MEDIA_TYPE_UUID
, 'DELINQUENCY_ID' IEU_PARAM_PK_COL
, TO_CHAR(IDEL.DELINQUENCY_ID) IEU_PARAM_PK_VALUE
, IDEL.DELINQUENCY_ID DELINQUENCY_ID
, 1 RESOURCE_ID
, IDEL.PARTY_CUST_ID CUSTOMER_ID
, 'RS_EMPLOYEE' RESOURCE_TYPE
, IPAR.PARTY_NAME PARTY_NAME
, IPAR.PERSON_FIRST_NAME FIRST_NAME
, IPAR.PERSON_LAST_NAME LAST_NAME
, IPAR.PARTY_TYPE PARTY_TYPE
, IDEL.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, IACC.ACCOUNT_NUMBER ACCOUNT_NUMBER
, IDEL.CUSTOMER_SITE_USE_ID SITE_USE_ID
, IDEL.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, TO_NUMBER('') AGING_BUCKET_LINE_ID
, '' BUCKET_NAME
, IDEL.TRANSACTION_ID TRANSACTION_ID
, IPAY.AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL
, IPAY.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING
, IPAY.TRX_NUMBER TRANSACTION_NUMBER
, IPAY.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, IPAY.DUE_DATE DUE_DATE
, IPAY.GL_DATE GL_DATE
, IPAY.TERM_ID TERM_ID
, IPAY.TERMS_SEQUENCE_NUMBER TERMS_SEQUENCE_NUMBER
, IDEL.AUTOASSIGN_YN AUTOASSIGN_YN
, IDEL.STATUS STATUS
, IDEL.CAMPAIGN_SCHED_ID CAMPAIGN_SCHED_ID
, AMS.SOURCE_CODE SOURCE_CODE
, IDEL.ORG_ID ORG_ID
, IDEL.CREATION_DATE CREATION_DATE
, IDEL.CREATED_BY CREATED_BY
, IDEL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IDEL.LAST_UPDATED_BY LAST_UPDATED_BY
, RS.SOURCE_NAME LAST_UPDATED_BYNAME
, IDEL.UWQ_STATUS UWQ_STATUS
, IDEL.UWQ_ACTIVE_DATE UWQ_ACTIVE_DATE
, IDEL.UWQ_COMPLETE_DATE UWQ_COMPLETE_DATE
, HU.NAME OPERATING_UNIT_NAME
FROM IEX_DELINQUENCIES IDEL
, AR_PAYMENT_SCHEDULES_ALL IPAY
, HR_OPERATING_UNITS HU
, AMS_SOURCE_CODES AMS
, HZ_CUST_ACCOUNTS IACC
, HZ_PARTIES IPAR
, JTF_RS_RESOURCE_EXTNS RS
, JTF_OBJECTS_B OBJB
WHERE IDEL.STATUS IN('DELINQUENT'
, 'PREDELINQUENT')
AND IDEL.PAYMENT_SCHEDULE_ID = IPAY.PAYMENT_SCHEDULE_ID(+)
AND IDEL.ORG_ID = IPAY.ORG_ID
AND IDEL.ORG_ID = HU.ORGANIZATION_ID
AND IPAY.STATUS = 'OP'
AND IDEL.CUST_ACCOUNT_ID = IACC.CUST_ACCOUNT_ID(+)
AND IDEL.CAMPAIGN_SCHED_ID = AMS.SOURCE_CODE_ID(+)
AND IDEL.PARTY_CUST_ID = IPAR.PARTY_ID
AND OBJB.OBJECT_CODE = 'IEX_DELINQUENCY'
AND IDEL.LAST_UPDATED_BY = RS.USER_ID(+) GROUP BY OBJB.OBJECT_FUNCTION
, OBJB.OBJECT_PARAMETERS
, TO_CHAR(IDEL.DELINQUENCY_ID)
, IDEL.DELINQUENCY_ID
, IDEL.PARTY_CUST_ID
, IPAR.PARTY_NAME
, IPAR.PERSON_FIRST_NAME
, IPAR.PERSON_LAST_NAME
, IPAR.PARTY_TYPE
, IDEL.CUST_ACCOUNT_ID
, IACC.ACCOUNT_NUMBER
, IDEL.CUSTOMER_SITE_USE_ID
, IDEL.PAYMENT_SCHEDULE_ID
, IDEL.TRANSACTION_ID
, IPAY.AMOUNT_DUE_ORIGINAL
, IPAY.AMOUNT_DUE_REMAINING
, IPAY.TRX_NUMBER
, IPAY.INVOICE_CURRENCY_CODE
, IPAY.DUE_DATE
, IPAY.GL_DATE
, IPAY.TERM_ID
, IPAY.TERMS_SEQUENCE_NUMBER
, IDEL.AUTOASSIGN_YN
, IDEL.STATUS
, IDEL.CAMPAIGN_SCHED_ID
, AMS.SOURCE_CODE
, IDEL.CREATION_DATE
, IDEL.CREATED_BY
, IDEL.LAST_UPDATE_DATE
, IDEL.LAST_UPDATED_BY
, RS.SOURCE_NAME
, IDEL.UWQ_STATUS
, IDEL.UWQ_ACTIVE_DATE
, IDEL.UWQ_COMPLETE_DATE
, IDEL.ORG_ID
, HU.NAME