Query to find the purchase order number from requisition number:
SELECT DISTINCT pha.segment1
FROM po_headers_all pha,po_distributions_all pda,po_req_distributions_all rda,
po_requisition_headers_all rha,po_requisition_lines_all rla
WHERE 1=1
AND pha.po_header_id=pda.po_header_id
AND pda.req_distribution_id=rda.distribution_id
AND rda.requisition_line_id=rla.requisition_line_id
AND rla.requisition_header_id=rha.requisition_header_id
AND rha.segment1=:P_REQ_NUM
Query to find the requisition number from purchase order number:
SELECT DISTINCT rha.segment1
FROM po_requisition_headers_all rha,po_requisition_lines_all rla,
po_req_distributions_all rda,po_distributions_all pda,po_headers_all pha
WHERE 1=1
AND rha.requisition_header_id=rla.requisition_header_id
AND rla.requisition_line_id=rda.requisition_line_id
AND rda.distribution_id=pda.req_distribution_id
AND pda.po_header_id=pha.po_header_id
AND pha.segment1=:P_PO_NUMBER
Thanks
Amar Alam
SELECT DISTINCT pha.segment1
FROM po_headers_all pha,po_distributions_all pda,po_req_distributions_all rda,
po_requisition_headers_all rha,po_requisition_lines_all rla
WHERE 1=1
AND pha.po_header_id=pda.po_header_id
AND pda.req_distribution_id=rda.distribution_id
AND rda.requisition_line_id=rla.requisition_line_id
AND rla.requisition_header_id=rha.requisition_header_id
AND rha.segment1=:P_REQ_NUM
Query to find the requisition number from purchase order number:
SELECT DISTINCT rha.segment1
FROM po_requisition_headers_all rha,po_requisition_lines_all rla,
po_req_distributions_all rda,po_distributions_all pda,po_headers_all pha
WHERE 1=1
AND rha.requisition_header_id=rla.requisition_header_id
AND rla.requisition_line_id=rda.requisition_line_id
AND rda.distribution_id=pda.req_distribution_id
AND pda.po_header_id=pha.po_header_id
AND pha.segment1=:P_PO_NUMBER
Thanks
Amar Alam
14 comments:
Thank you for taking the time to provide us with your valuable information. We strive to provide our candidates with excellent care.As always, we appreciate your confidence and trust in us..SAP Training in chennai
Thank you.. Priscilla..!!
This information is impressive; I am inspired with your post writing style & how continuously you describe this topic. After reading your post, thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic.
Online Reputation Management
We offer excellent My Assignment Help Service online where you'll get your tough assignments done even when the deadlines are short and you would like quality work urgently. Our assignment-writing experts work around the clock to make sure timely delivery of your assignments. Our assignment writers work on your assignments right from scratch and ensure delivery of 100% plagiarism free work whenever you place an order for assignment help online with Idealassignmenthelp.
I liked your blog and its information is very unique and useful. Thanks
Artificial Grass Dealers in Bangalore | Artificial Grass Price | Artificial Grass Wholesalers
You post is very informative and contents are outstanding. Thanks for sharing such useful info.
Zikia | OJOPLUS | Best Immune Booster Tablets in India
Purchase order meaning Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I'll be subscribing to your feed and I hope you post again soon. Big thanks for the useful info.
This article queries order numbers. It's an informative and interesting post. Keep sharing your content with us. Now it's time to get Vfix services https://www.vfixphonesandtech.com/ for more information.
Thanks for sharing such a nice article. Great information in this post. Its very helpful article. Amar alam app is good and technical world. Keep sharing more thoughts with us. Now it's time to get interior demolition for more information.
I truly appreciate your work, and the tips you give are helpful to me. I will share this information with my family and friends. This is a great website. Keep sharing more details about this article. Now it's time to get limo service Glendale az for more information.
Pretty remarkable post. I simply came across your blog and desired to say that I have really enjoyed searching your blog posts.
Now it's time to get Best track suits for men for more information.
Creative ideas are given in this article. Creativity at his best in this article. Keep share more ideas with us. Now its time to avail roller shutter repairs for more information.
Its a good way to write about this formula to help the person who is finding answer to this peoblem. Actually it should be on google or quora to help more readers. Now have a look yoga house dubai .
Post a Comment