Total Pageviews

March 5, 2016

3/05/2016 07:37:00 PM
Technical Query on Purchasing quotations

SELECT   pha.po_header_id,
         pha.segment1 quoteno,
         pha.quote_type_lookup_code,
         TRUNC (pha.creation_date) cdate,
         ppf.full_name buyer,
         h1.location_code shipto,
         pha.quote_vendor_quote_number quoteamt,
         h2.location_code billto,
         pha.currency_code curr,
         pv.vendor_name,
         pvs.address_line1,
         pvs.city,
         pvs.zip
  FROM   po_headers_all pha,
         per_all_people_f ppf,
         hr_locations h1,
         hr_locations h2,
         ap_suuplier_sites_all pvs,
         ap_supplier_sites_all pv
 WHERE       type_lookup_code = 'QUOTATION'
         AND pha.vendor_id = :p_vendor_id
         AND pha.agent_id = ppf.person_id
         AND pha.ship_to_location_id = h1.location_id
         AND pha.bill_to_location_id = h2.location_id
         AND pha.vendor_site_id = pvs.vendor_site_id
         AND pha.vendor_id = pv.vendor_id
LINE – QUERY

SELECT   pla.po_header_id,
         msi.segment1 item,
         msi.description itemdesc,
         mc.segment1 || ',' || mc.segment2 category,
         pla.unit_price price
  FROM   po_lines_all pla, mtl_system_items_b msi, mtl_categories mc
 WHERE       pla.item_id = msi.inventory_item_id
         AND pla.org_id = msi.organization_id
         AND pla.category_id = mc.category_id

Review Questions.

1) What is the Flow of Purchasing Module
2) Where the types of Requisition and table
3) Types of Purchase orders and tables
4) What is the different between standard PO and  Blanket PO
5) We have created a Item but which is not available in the pO what will be the problem
6) What are the types of Match approvals
7) What are the Receipt types
8) When we enter a Blanket Release data where it will be stored
9) If give the requisition no how to find out corresponding PO Numbers
10) If give the PO Number how to find out corresponding Receipt Numbers
11) What is Auto Create and Advantage
12) In which table we can find out
i) Shipped Quantity
ii) Received Quantity
iii) Canceled Quantity
13) Can we create Purchase order directly without
i) Requisition,
ii) RFQ
iii) Quotation
14) Can we have the Receipt without Purchase order
15) What are the tables for RFQ, Quotation, Purchase Order

0 comments:

Post a Comment