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
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
