VIEW: APPS.IEX_CU_PRO_ALL_UWQ_V

Source

View Text - Preformatted

SELECT summ.dln_uwq_summary_id dln_uwq_summary_id, summ.org_id org_id, summ.collector_id collector_id, summ.collector_resource_id collector_resource_id, summ.collector_res_type collector_res_type, summ.ieu_object_function ieu_object_function, REPLACE(summ.ieu_object_parameters, 'IEXTRMAN', 'IEXHIOVW DISPLAYTYPE=PROMISE') || ' RETURNED_FROM=IEUSEUWQ MO_DEFAULT_ORG_ID=' || summ.org_id ieu_object_parameters, summ.ieu_media_type_uuid ieu_media_type_uuid, summ.ieu_param_pk_col ieu_param_pk_col, summ.ieu_param_pk_value ieu_param_pk_value, summ.resource_id resource_id, summ.resource_type resource_type, summ.party_id party_id, summ.party_name party_name, summ.cust_account_id cust_account_id, summ.account_name account_name, summ.account_number account_number, summ.site_use_id site_use_id, summ.location location, summ.currency currency, summ.op_invoices_count op_invoices_count, summ.op_debit_memos_count op_debit_memos_count, summ.op_deposits_count op_deposits_count, summ.op_bills_receivables_count op_bills_receivables_count, summ.op_chargeback_count op_chargeback_count, summ.op_credit_memos_count op_credit_memos_count, summ.unresolved_cash_count unresolved_cash_count, summ.disputed_inv_count disputed_inv_count, summ.best_current_receivables best_current_receivables, summ.op_invoices_value op_invoices_value, summ.op_debit_memos_value op_debit_memos_value, summ.op_deposits_value op_deposits_value, summ.op_bills_receivables_value op_bills_receivables_value, summ.op_chargeback_value op_chargeback_value, summ.op_credit_memos_value op_credit_memos_value, summ.unresolved_cash_value unresolved_cash_value, summ.receipts_at_risk_value receipts_at_risk_value, summ.inv_amt_in_dispute inv_amt_in_dispute, summ.pending_adj_value pending_adj_value, summ.past_due_inv_value past_due_inv_value, summ.past_due_inv_inst_count past_due_inv_inst_count, summ.last_payment_date last_payment_date, summ.last_payment_amount last_payment_amount, summ.last_payment_amount_curr last_payment_amount_curr, summ.last_payment_number last_payment_number, summ.last_update_date last_update_date, summ.last_updated_by last_updated_by, summ.creation_date creation_date, summ.created_by created_by, summ.last_update_login last_update_login, summ.number_of_delinquencies number_of_delinquencies, summ.active_delinquencies active_delinquencies, summ.complete_delinquencies complete_delinquencies, summ.pending_delinquencies pending_delinquencies, summ.score score, summ.address1 address1, summ.city city, summ.state state, summ.county county, summ.country country, summ.province province, summ.postal_code postal_code, summ.phone_country_code phone_country_code, summ.phone_area_code phone_area_code, summ.phone_number phone_number, summ.phone_extension phone_extension, summ.number_of_bankruptcies number_of_bankruptcies, summ.number_of_promises number_of_promises, summ.broken_promise_amount broken_promise_amount, summ.promise_amount promise_amount, summ.active_promises active_promises, summ.complete_promises complete_promises, summ.pending_promises pending_promises, summ.work_item_id work_item_id, summ.schedule_start schedule_start, summ.schedule_end schedule_end, summ.work_type work_type, summ.category_type category_type, summ.priority_type priority_type, hu.name operating_unit_name FROM iex_dln_uwq_summary summ, hr_operating_units hu WHERE nvl(number_of_promises, 0) > 0 AND summ.org_id = hu.organization_id AND mo_global.check_access(summ.org_id) = 'Y'

View Text - HTML Formatted

SELECT SUMM.DLN_UWQ_SUMMARY_ID DLN_UWQ_SUMMARY_ID
, SUMM.ORG_ID ORG_ID
, SUMM.COLLECTOR_ID COLLECTOR_ID
, SUMM.COLLECTOR_RESOURCE_ID COLLECTOR_RESOURCE_ID
, SUMM.COLLECTOR_RES_TYPE COLLECTOR_RES_TYPE
, SUMM.IEU_OBJECT_FUNCTION IEU_OBJECT_FUNCTION
, REPLACE(SUMM.IEU_OBJECT_PARAMETERS
, 'IEXTRMAN'
, 'IEXHIOVW DISPLAYTYPE=PROMISE') || ' RETURNED_FROM=IEUSEUWQ MO_DEFAULT_ORG_ID=' || SUMM.ORG_ID IEU_OBJECT_PARAMETERS
, SUMM.IEU_MEDIA_TYPE_UUID IEU_MEDIA_TYPE_UUID
, SUMM.IEU_PARAM_PK_COL IEU_PARAM_PK_COL
, SUMM.IEU_PARAM_PK_VALUE IEU_PARAM_PK_VALUE
, SUMM.RESOURCE_ID RESOURCE_ID
, SUMM.RESOURCE_TYPE RESOURCE_TYPE
, SUMM.PARTY_ID PARTY_ID
, SUMM.PARTY_NAME PARTY_NAME
, SUMM.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, SUMM.ACCOUNT_NAME ACCOUNT_NAME
, SUMM.ACCOUNT_NUMBER ACCOUNT_NUMBER
, SUMM.SITE_USE_ID SITE_USE_ID
, SUMM.LOCATION LOCATION
, SUMM.CURRENCY CURRENCY
, SUMM.OP_INVOICES_COUNT OP_INVOICES_COUNT
, SUMM.OP_DEBIT_MEMOS_COUNT OP_DEBIT_MEMOS_COUNT
, SUMM.OP_DEPOSITS_COUNT OP_DEPOSITS_COUNT
, SUMM.OP_BILLS_RECEIVABLES_COUNT OP_BILLS_RECEIVABLES_COUNT
, SUMM.OP_CHARGEBACK_COUNT OP_CHARGEBACK_COUNT
, SUMM.OP_CREDIT_MEMOS_COUNT OP_CREDIT_MEMOS_COUNT
, SUMM.UNRESOLVED_CASH_COUNT UNRESOLVED_CASH_COUNT
, SUMM.DISPUTED_INV_COUNT DISPUTED_INV_COUNT
, SUMM.BEST_CURRENT_RECEIVABLES BEST_CURRENT_RECEIVABLES
, SUMM.OP_INVOICES_VALUE OP_INVOICES_VALUE
, SUMM.OP_DEBIT_MEMOS_VALUE OP_DEBIT_MEMOS_VALUE
, SUMM.OP_DEPOSITS_VALUE OP_DEPOSITS_VALUE
, SUMM.OP_BILLS_RECEIVABLES_VALUE OP_BILLS_RECEIVABLES_VALUE
, SUMM.OP_CHARGEBACK_VALUE OP_CHARGEBACK_VALUE
, SUMM.OP_CREDIT_MEMOS_VALUE OP_CREDIT_MEMOS_VALUE
, SUMM.UNRESOLVED_CASH_VALUE UNRESOLVED_CASH_VALUE
, SUMM.RECEIPTS_AT_RISK_VALUE RECEIPTS_AT_RISK_VALUE
, SUMM.INV_AMT_IN_DISPUTE INV_AMT_IN_DISPUTE
, SUMM.PENDING_ADJ_VALUE PENDING_ADJ_VALUE
, SUMM.PAST_DUE_INV_VALUE PAST_DUE_INV_VALUE
, SUMM.PAST_DUE_INV_INST_COUNT PAST_DUE_INV_INST_COUNT
, SUMM.LAST_PAYMENT_DATE LAST_PAYMENT_DATE
, SUMM.LAST_PAYMENT_AMOUNT LAST_PAYMENT_AMOUNT
, SUMM.LAST_PAYMENT_AMOUNT_CURR LAST_PAYMENT_AMOUNT_CURR
, SUMM.LAST_PAYMENT_NUMBER LAST_PAYMENT_NUMBER
, SUMM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SUMM.LAST_UPDATED_BY LAST_UPDATED_BY
, SUMM.CREATION_DATE CREATION_DATE
, SUMM.CREATED_BY CREATED_BY
, SUMM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SUMM.NUMBER_OF_DELINQUENCIES NUMBER_OF_DELINQUENCIES
, SUMM.ACTIVE_DELINQUENCIES ACTIVE_DELINQUENCIES
, SUMM.COMPLETE_DELINQUENCIES COMPLETE_DELINQUENCIES
, SUMM.PENDING_DELINQUENCIES PENDING_DELINQUENCIES
, SUMM.SCORE SCORE
, SUMM.ADDRESS1 ADDRESS1
, SUMM.CITY CITY
, SUMM.STATE STATE
, SUMM.COUNTY COUNTY
, SUMM.COUNTRY COUNTRY
, SUMM.PROVINCE PROVINCE
, SUMM.POSTAL_CODE POSTAL_CODE
, SUMM.PHONE_COUNTRY_CODE PHONE_COUNTRY_CODE
, SUMM.PHONE_AREA_CODE PHONE_AREA_CODE
, SUMM.PHONE_NUMBER PHONE_NUMBER
, SUMM.PHONE_EXTENSION PHONE_EXTENSION
, SUMM.NUMBER_OF_BANKRUPTCIES NUMBER_OF_BANKRUPTCIES
, SUMM.NUMBER_OF_PROMISES NUMBER_OF_PROMISES
, SUMM.BROKEN_PROMISE_AMOUNT BROKEN_PROMISE_AMOUNT
, SUMM.PROMISE_AMOUNT PROMISE_AMOUNT
, SUMM.ACTIVE_PROMISES ACTIVE_PROMISES
, SUMM.COMPLETE_PROMISES COMPLETE_PROMISES
, SUMM.PENDING_PROMISES PENDING_PROMISES
, SUMM.WORK_ITEM_ID WORK_ITEM_ID
, SUMM.SCHEDULE_START SCHEDULE_START
, SUMM.SCHEDULE_END SCHEDULE_END
, SUMM.WORK_TYPE WORK_TYPE
, SUMM.CATEGORY_TYPE CATEGORY_TYPE
, SUMM.PRIORITY_TYPE PRIORITY_TYPE
, HU.NAME OPERATING_UNIT_NAME
FROM IEX_DLN_UWQ_SUMMARY SUMM
, HR_OPERATING_UNITS HU
WHERE NVL(NUMBER_OF_PROMISES
, 0) > 0
AND SUMM.ORG_ID = HU.ORGANIZATION_ID
AND MO_GLOBAL.CHECK_ACCESS(SUMM.ORG_ID) = 'Y'