Oracle Apps -Learn and grow

Query for Modifiers and Qualifiers in Oracle-R12 Pricing Price List :           Price lists are essential for ordering products bec...

TCA Sr. No. Detail API Name  Module 1 Cre...

SQL Query To find the PO Lines from the Purchase Order  select * from  PO_HEADERS_ALL PHA, PO_LINES_ALL PLA WHERE PHA.PO_HEADER_ID=PLA.PO_HE...

Importing journals Oracle Apps R12 To prepare for importing journals: 1. Define all account segment values used in your feeder systems...

  Task: How to find a AP invoice is validated or not through a SQL query Script: SELECT i.invoice_id,        i.invoice_amount,        DECODE...

Reasons for a sales order to get Backordered Back Orders: The Oracle "term" backorder is a "status" on the order ...

Query for Secondary Price list for customer account The pricing engine uses secondary price lists when it cannot determine the price for...

How to find Approver of Requisition in oracle Apps R12 SELECT distinct papf.full_name                    FROM po.po_action_history pah...

AP_INV_APRVL_HIST_ALL table will give you all the details related to approval of particular invoice. Query to get the latest transaction on ...

List of tables based on module and schema in oracle Apps R-12 Tables related to order management module ...