'and corrid like ''' || t.correlation_id || ''' ', WHERE corrid LIKE '%oracle.apps.wsh.sup.ssro', Oracle MSCA- Mobile Supply Chain Applications, Oracle MSCA - Bar code preprocessing using CustomScanManager, Oracle MSCA - Enabling Personalization for MSCA Pages, Oracle MSCA - Changing Prompts & DFI for out of order scanning, Oracle MSCA - Function Keys on Windows Mobile, Oracle MSCA - Automatic Navigation after scanning, OA Fwk - Getting Started - Create an EO/VO, OA Fwk - Creating a Results Based Search Page, OA Fwk - Simple Search - Auto Customization Criteria, Enabling Audit Trail in Oracle Apps Release 12. xlal.unrounded_accounted_dr The book covers schema design, SQL and PL/SQL, tables and indexes, and much more. From the exclusive publisher of Oracle Press books, this is a must-have resource for all Oracle developers and DBAs. Query to Get Payable Invoice Details in Oracle Fusion ERP Application. google_ad_host="pub-6693688277674466"; An exhaustive book and ebook resource for PeopleSoft Financials application practitioners to understand core concepts, configurations, and business processes. h.name journal_name, h.status journal_status, h.creation_date je_created_date, . Let's begin. --query to find records that are pending in each of the workflow agent listener queues. Query to Get PO, Receipt, Invoice Number in Oracle Apps R12.