Entries by Oracle ERP Apps Guide

, , , , , ,

P2P Flow SQL Query Link

select prh.segment1 “PO Requisition Number”,       pha.segment1 “PO Number”,       aps.SEGMENT1 “Supplier Number”,       aps.vendor_name,       apss.vendor_site_code,       apsc.first_name,       apsc.last_name,       pla.item_id,       plla.ship_to_organization_id,       plla.ship_to_location_id,       rt.transaction_type,       rt.destination_type_code,       rsh.receipt_num “PO Receipt Number”,       aia.invoice_num,       aida.dist_code_combination_id,       aca.check_number,gjh.ledger_id,       gjh.name  from po_requisition_headers_all prh,       po_requisition_lines_all prl,       po_req_distributions_all prd,       po_headers_all pha,       po_lines_all pla,       po_distributions_all pda,       po_line_locations_all plla,       ap_suppliers aps,       ap_supplier_sites_all apss,       ap_supplier_contacts apsc,       rcv_transactions rt,       rcv_shipment_headers rsh,       rcv_shipment_lines rsl,       […]

/by
, , , , , , ,

O2C Flow SQL Query Link

select ooha.order_number,ooha.org_id,       hca.account_name,       hp.party_name “Customer Name”,       hcasab.orig_system_reference      BILL_TO_ORIG_REF,       hpsb.status                       BILL_TO_STATUS,       ‘ADDRESS1 – ‘||bill_loc.address1||’,’||CHR(10)|| ‘ADDRESS2 – ‘||bill_loc.address2||’,’||CHR(10)||       ‘ADDRESS3 – ‘||bill_loc.address3||’,’||CHR(10)|| ‘CITY     – ‘||bill_loc.city||’,’||CHR(10)||       ‘POSTAL CD- ‘||bill_loc.postal_code||’,’||CHR(10)|| ‘COUNTRY  – ‘|| bill_loc.country  BILL_TO_ADDRESS,       hcasas.orig_system_reference      SHIP_TO_ORIG_REF,        hpss.status SHIP_TO_STATUS,       ‘ADDRESS1 – ‘||ship_loc.address1||’,’||CHR(10)|| ‘ADDRESS2 – ‘||ship_loc.address2||’,’||CHR(10)||       ‘ADDRESS3 – ‘||ship_loc.address3||’,’||CHR(10)|| ‘CITY     – ‘||ship_loc.city||’,’||CHR(10)||       ‘POSTAL CD- ‘||ship_loc.postal_code||’,’||CHR(10)|| ‘COUNTRY  – ‘|| ship_loc.country  SHIP_TO_ADDRESS,       […]

/by
, , , ,

Order Management Tables and its details

Order Management Tables. Enteredoe_order_headers_all 1 record created in header tableoe_order_lines_all Lines for particular recordsoe_price_adjustments When discount gets appliedoe_order_price_attribs If line has price attributes then populatedoe_order_holds_all If any hold applied for order like credit check etc.Bookedoe_order_headers_all Booked_flag=Y Order booked.wsh_delivery_details Released_status Ready to releasePick Released wsh_delivery_details Released_status=Y Released to Warehouse (Line has been released to Inventory for […]

/by
, , , , ,

Order Management Drop Shipment, Functional Setup and flow

 E-commerce site like ebay, ubid.com and amazon.com which are very common place in advance countries like USA, UK & Singapore where people can sell or buy there product. Have you ever think ,what is similar situation in real world , when the the word ‘drop shipment’ comes to your mind. ……a business situation when the […]

/by
, , , , ,

Accounts Receivables (AR) Tables Information

RA_CUSTOMER_TRX_ALL This table stores invoice, debit memo, commitment, and credit memo header information. Each row includes general invoice information such as customer, transaction type, and printing instructions. You need one row for each invoice, debit memo, commitment, and credit memo you create in Oracle Receivables. Invoices, debit memos, credit memos, and commitments are all distinguished […]

/by