Joins

By -
Simple or Inner Join: Fetch the record only matched rows from  primary table and secondary table.
Right Outer Join: Fetch the record  matched rows from primary table and secondary table and unmatched rows from the secondary table.
Left Outer Join:Fetch the record  matched rows from both table primary and secondary table and unmatched rows from primary table.  

Comments

Post a Comment

Popular posts from this blog

JD Edwards Sales Interview questions and Answers

By abhishek shukla -
Q1: Explain the Sales Process with Program Numbers The typical sales process involves the following steps and corresponding programs: Sales Order Entry : Program: P4210 The sales order comprises a header and details : Header Information : Stored in table F4201 (Sales Order Header file) and includes branch plant, customer details (sold-to and ship-to), order date, payment terms, and shipping information. Detail Information : Stored in table F4211 (Sales Order Detail file) and includes item number, quantity, price, promised ship and delivery dates, etc. Multiple line items with similar details can exist. Additional Features : Use advanced pricing to access the price breakup screen and manually override prices if necessary. Inventory can be hard committed during order entry. Last/Next Status: 520/540 Credit Check : If the order amount exceeds open credit, the order is put on hold. The credit and collection department can release the hold. Print Pick Slip : Program: R42520 (Batch appli...
Read more

Header Detail form

By abhishek shukla -
The Header Detail form allows you to work with data from two separate tables. You can use this form to add or update a single header record. You can also add, update, or delete multiple detail records from the same form. The Header Detail form includes an input-capable grid so you can add or update detail records. Click OK to perform updates or adds to both tables on the form. When you click Cancel, any changes are lost and no database changes are made. Because the Header Detail form allows you to update or add records from two different tables, you can attach two business views to a Header Detail form. Attach one business view to the grid and the other to the form, updating both tables from a single form. You can use the Header Detail form for one to many relationships.
Read more

Commitment Types in JDE

By abhishek shukla -
  Commitment Types in JDE Inventory commitment in JD Edwards EnterpriseOne can be classified into three types: Soft Commitment , Hard Commitment , and Future Commitment . Each type is determined by specific processes and system configurations. Soft Commitment Does not specify a particular location for inventory removal. Uses the primary location as the default at the time of order entry. Hard Commitment Typically occurs during the Print Pick Slips process ( R42520 ) but can be triggered at any stage in the sales order process by running Inventory Commitment ( R42997 ). Specifies a location ( SDLOCN ) or lot ( SDLOTN ) other than the primary in the Sales Order Detail (F4211) during Sales Order Entry ( P4210 ). Future Commitment Applies to orders with a future Promised Ship Date (PPDJ) set during Sales Order Entry ( P4210 ). Controlled by the Specific Commitment Days (COMH) field in Branch Plant Constants (P41001) . Requires running the Re-Commit Future Order...
Read more