ECC Receivables, Payment Process, SQL4

Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: ar-pmtproc
Query Procedure: AR_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: AR_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
Run ECC Receivables, Payment Process, SQL4 and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
select * from (SELECT transmis_v.OPERATING_UNIT
, transmis_v.LEDGER_CURRENCY
, transmis_v.LEDGER_CURRENCY_CODE
, transmis_v.LEDGER
, transmis_v.TRANSMISSION_NAME
, transmis_v.CREATION_DATE
, transmis_v.STATUS
, transmis_v.LOCKBOX_NUMBER
, transmis_v.NUMBER_OF_ERRORS
, transmis_v.ORG_ID
, transmis_v.TRANSMISSION_ID
, transmis_v.ECC_SPEC_ID
, transmis_v.ECC_LAST_UPDATE_DATE
, transmis_v.RECORD_TYPE
, transmis_v.LANGUAGE
  FROM ar_ecc_transmission_error_v transmis_v, ar_ecc_process_t process_t
 WHERE transmis_v.transmission_id = process_t.id
   AND process_t.record_type = 'ARLOCKBOX' AND transmis_v.LANGUAGE in ('US'))
   PIVOT(max(OPERATING_UNIT) as OPERATING_UNIT, max(LEDGER_CURRENCY) as LEDGER_CURRENCY, max(STATUS) as STATUS
   for LANGUAGE in ('US' "US"))
) x
where
2=2
Parameter Name SQL text Validation
Operating Unit
x.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)
LOV