ECC Receivables, Payment Process, SQL2
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
Dataset Key: ar-pmtproc
Query Procedure: AR_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: AR_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
select x.* from ( select * from (SELECT /*+ leading(rcptbatch_v.temp.process_t) full(rcptbatch_v.temp.process_t) no_push_pred(rcptbatch_v.temp) */ rcptbatch_v.OPERATING_UNIT , rcptbatch_v.LEDGER_CURRENCY , rcptbatch_v.LEDGER_CURRENCY_CODE , rcptbatch_v.LEDGER , rcptbatch_v.RECEIPT_METHOD , rcptbatch_v.RECEIPT_BATCH_NUMBER , rcptbatch_v.RECEIPT_BATCH_SOURCE , rcptbatch_v.RECEIPT_BATCH_DATE , rcptbatch_v.RECEIPT_BATCH_STATUS , rcptbatch_v.RECEIPT_BATCH_PROCESS_STATUS as RCPT_BATCH_PROC_STAT , rcptbatch_v.RECEIPT_BATCH_TYPE , rcptbatch_v.RECEIPT_BATCH_CURRENCY , rcptbatch_v.RECEIPT_BATCH_CURRENCY_CODE , rcptbatch_v.RECIPT_CONTROL_COUNT , rcptbatch_v.RECIPT_ACTUAL_COUNT , rcptbatch_v.ORG_ID , rcptbatch_v.RECEIPT_BATCH_ID , rcptbatch_v.ECC_SPEC_ID , rcptbatch_v.ECC_LAST_UPDATE_DATE , rcptbatch_v.RECORD_TYPE , rcptbatch_v.LANGUAGE FROM ar_ecc_receipt_batch_v rcptbatch_v WHERE rcptbatch_v.language in ('US')) PIVOT(max(OPERATING_UNIT) as OPERATING_UNIT, max(LEDGER_CURRENCY) as LEDGER_CURRENCY, max(RECEIPT_BATCH_CURRENCY) as RECEIPT_BATCH_CURRENCY, max(RECEIPT_BATCH_STATUS) as RECEIPT_BATCH_STATUS,max(RCPT_BATCH_PROC_STAT) as RCPT_BATCH_PROC_STAT, max(RECEIPT_BATCH_TYPE) as RECEIPT_BATCH_TYPE for LANGUAGE in ('US' "US")) ) x where 2=2 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Operating Unit |
|
LOV |