SQL Query To find the PO Vendor Name from the Purchase Order select ASP.* from PO_HEADERS_ALL PHA,AP_SUPPLIERS ASPWHERE PHA.VENDOR_ID=ASP.VENDOR_ID AND PHA.SEGMENT1=:PO_NUMBERAND PHA.ORG_ID=:ORG_IDSQL Query To find the PO Vendor SITE from the Purchase Order select ASSA.* from PO_HEADERS_ALL PHA,AP_SUPPLIER_SITES_ALL ASSAWHERE PHA.VENDOR_SITE_ID=ASSA.VENDOR_SITE_IDAND PHA.SEGMENT1=:PO_NUMBERAND PHA.ORG_ID=:ORG_IDSQL Query To find the PO Matching AP Invoice Numbers from ...
SQL Query To find the PO Lines from the Purchase Order select * from PO_HEADERS_ALL PHA,PO_LINES_ALL PLAWHERE PHA.PO_HEADER_ID=PLA.PO_HEADER_IDAND PHA.SEGMENT1=:PO_NUMBERAND PHA.ORG_ID=:ORG_IDSQL Query To find the PO Distributions Data from the Purchase Orderselect PDA.* from PO_HEADERS_ALL PHA,PO_DISTRIBUTIONS_ALL PDAWHERE PHA.PO_HEADER_ID=PDA.PO_HEADER_IDAND PHA.SEGMENT1=:PO_NUMBERAND PHA.ORG_ID=:ORG_IDSQL Query To find the PO Receipts from the Purchase Order select * from rcv_shipment_lines ...
PO_HEADERS_ALL :This is the Purchase Order Headers Table in Oracle Apps. Here below you will find po_headers_all table columns details.We can find the po number in po_headers_all in Segment1 Column of PO_HEADERS_ALL table.This table have information's like PO Number, PO Type , Vendor Id ,Vendor Site Id, Currency ,PO Status.PO_LINES_ALL :Here's Below we can find po_lines_all table description This is the PO Lines Tables in Oracle Apps. In This Table We have Item Id , Qty , Item Description ...
How to Unlock the Locked Table in ORACLEYour package in not getting compiled and its keep on running forever? Are you getting lock objects issue? Is Oracle throwing error as ORA-04021 :timeout occurredIf Yes then its not your connection issue or system issue. Its issue with the objects which you are trying to compile.Oracle puts locks while performing any DDL or DML operation on oracle tables. When table locks is present on any tables in Oracle we cannot run DDL on those tables. Some ...
Base Tables in Oracle Payables(AP):The base tables in AP are as follows:1) AP_INVOICES_ALL2) AP_INVOICE_PAYMENTS_ALL3) AP_INVOICE_DISTRIBUTIONS_ALL4) AP_PAYMENT_SCHEDULES_ALL5)AP_PAYMENT_HISTORY_ALL 6)AP_CHECKS_ALL7) AP_HOLDS_ALL 8) AP_AE_LINES_ALL9) AP_AE_HEADERS_ALL1) AP_INVOICES_ALL:AP_INVOICES_ALL contains records for invoices you enter. There is one row for each invoice you enter. An invoice can have one or more invoice distribution lines. An invoice can also have one or more ...
