Drop Ship tables in Order Management

-


Table
Description
PO_LINE_LOCATIONS_ALL
Stores document shipment schedules for purchase orders,
purchase Agreements, quotations, and RFQs
PO_LINES_ALL
Stores purchase document lines for purchase orders,
purchase agreements, quotations, and RFQs
PO_HEADERS_ALL
Stores document headers for purchase orders, purchase
agreements, quotations, and RFQs
PO_DISTRIBUTIONS_ALL
Stores purchase order distributions
PO_REQUISITION_HEADERS_ALL
Stores requisition headers
PO_REQUISITION_LINES_ALL
Stores requisition lines
PO_REQ_DISTRIBUTIONS_ALL
This table stores requisition distributions
PO_REQUISITIONS_INTERFACE_ALL
This is the Requisition Import interface table
OE_ORDER_LINES_ALL
Stores information for all order lines in Oracle Order
Management
RCV_SHIPMENT_LINES
Stores receiving shipment line information
OE_DROP_SHIP_SOURCES
Stores relationships between order lines in
oe_order_lines_all table and associated oracle purchasing
requisitions in PO_REQUISITIONS_ALL and Oracle
purchasing purchase orders in PO_LINES_ALL

Comments

  1. Sangeetha Arul13 October 2015 at 21:24

    I really appreciate your post and you explain each and every point very well. Thanks for sharing this information. And I’ll love to read your next post too.

    Order Management System

    ReplyDelete
  2. Unknown15 July 2016 at 23:49

    This comment has been removed by the author.

    ReplyDelete
  3. THAHA12 October 2016 at 01:13

    Hi,

    could you please provide some guidance on how to add direct expenses if any the item cost in dropship method ? i have a similar situation.

    Regards
    thaha

    ReplyDelete
  4. Unknown31 March 2017 at 00:10

    I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Oracle E-Business Functional Workflow for R12
    , kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on Oracle E-Business Functional Workflow for R12 . We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us:
    Name : Arunkumar U
    Email : arun@maxmunus.com
    Skype id: training_maxmunus
    Contact No.-+91-9738507310
    Company Website –http://www.maxmunus.com



    ReplyDelete
  5. Samiullah20 June 2019 at 03:26

    You made such an interesting piece to read, giving every subject enlightenment for us to gain knowledge. Thanks for sharing the such information with us to read this... Drop Shipping Agreement

    ReplyDelete
  6. Samiullah20 June 2019 at 03:26

    We are really grateful for your blog post. You will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work. Dropshipping Agreement

    ReplyDelete
  7. Sale Source19 April 2021 at 01:21

    Lopoking for the dropshipping management tool visit Sale Source? It is specially designed to help businesses with management. It is also helpful for hands-off communication with dropshippers. Explore now for more info.

    ReplyDelete
  8. Auto Transport Company16 August 2023 at 01:13

    Looking for the Auto shipping company visit this company ? It is specially services to help shipping your vehicle.Auto Shipping Company

    ReplyDelete

Post a Comment

Popular posts from this blog

Oracle Purchasing Module Step by Step in R12

-
Image
PURCHASING  All the Purchasing related activity information will be declared in Purchasing              Procure 2 Pay Cycle : Requisition à RFQ à Quotation à Quotation Analysis à Purchasing à Receiving à Invoice  à  Payment à Reconciliation PO-Integration :  PO  is integrated by GL, AP, I Supplier, Procurement, and Project Accounting  PO  Responsibility             Step1: Define  PO  Responsibility                         Nav: System administrator à Security à Responsibility à Define             Step2: Assign  PO  options to the PO Responsibility                         Nav: System administrator à Profile à system             Step3: Assign  PO  Responsibility to User                         Nav: System administrator à security à user à define Note:  PO  is including some of i.e. Options, Supplier, Item, Expenses, and Purchasing . Options : Options nothing but a Controlling future at the operating unit level.                         Th
Read more

Difference between ATO and PTO in oracle apps

-
Difference between ATO and PTO in oracle apps 1) MAKE TO ORDER: This is based on Customer specification, you make the product and supply it to them. This is applicable for Engineering items or any Product which you can make based on Customer order Example: Engineering Items 2) ASSEMBLE TO ORDER: This is you have items in parts and it needs to be assembled according to customer requirements For example you have Laptop coming with standard configuration of 160GB Hard disk and 1 GB RAM. But there are customer orders coming in asking for 200GB Hard Disk and 2 GB RAM and if you can assemble them to suit Customer Requirement 3) CONFIGURE TO ORDER: This is Configuring the Product itself to suit Customer requirements Example. The Thread Manufacturing unit Machineries are configured. I have seen Laxmi Machine Works in INDIA which manufactures textile Machineries configure the machineries based on No.of spindles 4) PICK TO ORDER: This is same as Computer Example in ATO. But the  difference is
Read more

Sub Ledger Accounting SLA (Complete Functional Information)

-
Image
SubLegder Accounting in R12 SLA Part -1 In these article, we will explore the very basics of SLA and why it exists. Firstly, what exactly does SLA do? SLA is a module which now sits between the SubLedgers like AP/AR etc and the General Ledger. Have a look at this diagram below.  As you will notice, SLA can act as a mediator between the subledgers and Oracle General Ledger. Before we progress, some terminologies of R12 must be revisited. In 11i we had set of books, and in R12 we call them Ledgers. Likewise in R12 we also have secondary ledgers and reporting ledgers. Hence from 11i perspective think of Ledger as Set of Books. As for Subledger, a Subledger is nothing but a module like AP/AR/PO/Inventory etc. In the diagram below, the second scenario is explained whereby let's say that payables module generates a charge account segment combination for an invoice distribution line as A.B.C.D. In such case, if SLA module is not customized, then the very same A.B.C.D
Read more