Since 2010, OraERP is a Oracle Forums, Community of Oracle Professionals including Fusion/Cloud Application Consultants, Enterprise Architects, ERP Cloud, HCM Cloud, CX Cloud and OCI Experts, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Digital Architect, PaaS Experts, IaaS, OCI Architects, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to OraERP.com Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick and Simple. Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips .
Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities
›
Oracle Applications
›
Oracle E-Business Suite (EBS)
›
Oracle Financials
Need exact values of invoice status and accounted in query?
Need exact values of invoice status and accounted in query?
|
Need exact values of invoice status and accounted in query?
|
|
11-09-2014, 06:35 PM,
|
|||
|
|||
|
Need exact values of invoice status and accounted in query?
One of my clients required getting values of invoice status and accounted fields, the query which is used; there are no columns which are getting these values but functions instead. apps.AP_INVOICES_PKG.GET_POSTING_STATUS(invoice_id) And other is APPS.AP_INVOICES_PKG.GET_APPROVAL_STATUS(invoice_id,invoice_amount,payment_status_flag,invoice_type_lookup_code) These functions return values are not the same as shown on invoice Form, m too much confused how can handle it. Thanks, Chakra |
|||
|
11-13-2014, 04:55 PM,
|
|||
|
|||
|
RE: Need exact values of invoice status and accounted in query?
For invoice validation status, check this query, it will be helpfull select ( decode ( apps.ap_invoices_pkg.get_approval_status (invoice_id, invoice_amount, payment_status_flag, invoice_type_lookup_code ), 'FULL', 'Fully Applied', 'UNAPPROVED', 'Unvalidated', 'NEEDS REAPPROVAL', 'Needs Revalidation', 'APPROVED', 'Validated', 'NEVER APPROVED', 'Never Validated', 'CANCELLED', 'Cancelled', 'UNPAID', 'Unpaid', 'AVAILABLE', 'Available')) invoice_status from ap_invoices_all l where l.INVOICE_NUM = 'XXX' Regards, |
|||
|
12-24-2019, 05:44 AM,
|
|||
|
|||
|
RE: Need exact values of invoice status and accounted in query?
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинйоинфоинфоинфоинфоинфо инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо |
|||
|
« Next Oldest | Next Newest »
|
| Possibly Related Threads… | |||||
| Thread | Author | Replies | Views | Last Post | |
| Different payment method for one invoice | Rubab Ali | 4 | 5,383 |
12-24-2019, 09:52 AM Last Post: viggora |
|
| How we can bring AP Invoice attachments through the FA Mass Additions Process in R12 | Saleem Akhtar | 3 | 5,519 |
12-24-2019, 09:35 AM Last Post: viggora |
|
| How can we update the invoice number in AP | Harish Duleep | 3 | 5,027 |
12-24-2019, 09:17 AM Last Post: viggora |
|
| How to create AP invoice for Delivered Quantity | Santosh | 3 | 4,319 |
12-24-2019, 09:07 AM Last Post: viggora |
|
| How t query AR on Account Receipts | Mukhtar Ali | 3 | 9,331 |
12-24-2019, 08:42 AM Last Post: viggora |
|
| How can check delay invoice listing | Joseph George | 3 | 3,871 |
12-24-2019, 07:39 AM Last Post: viggora |
|
| Hold “no payee bank a/c” for invoice with Electronic payment method | Anumeha Manish | 3 | 5,718 |
12-24-2019, 07:37 AM Last Post: viggora |
|
| AR intercompany invoice not created in oracle r12 | Lewis Jacob | 2 | 4,549 |
12-24-2019, 07:32 AM Last Post: viggora |
|
| Invoice status “Needs Revalidation” | Rachel Hannah | 4 | 17,576 |
12-24-2019, 06:34 AM Last Post: viggora |
|
| Cannot find Opeating Unit name in Invoice entry page | ameysangle | 5 | 5,123 |
12-24-2019, 06:26 AM Last Post: viggora |
|
Users browsing this thread: 2 Guest(s)