Oracle Purchasing Queries
**Query to obtain PO/PR Select Distinct Pha.Segment1 Po#, Pha.Po_Header_Id, Pha.Creation_Date, Pha.Approved_Date, Pda.Po_Header_Id Pda_Po_Header_Id, Prha.Segment1 Pr# From Apps.Po_Headers_All Pha, Apps.Po_Distributions_All Pda, Apps.Po_Req_Distributions_All Prda, Apps.Po_Requisition_Lines_All Prla, Apps.Po_Requisition_Headers_All Prha Where Pha.Org_Id=123 And Pda.Po_Header_Id=Pha.Po_Header_Id And Prda.Distribution_Id=Pda.Req_Distribution_Id And Prla.Requisition_Line_Id=Prda.Requisition_Line_Id And Prha.Requisition_Header_Id=Prla.Requisition_Header_Id And Pha.Segment1 = '900000' And Prha.Segment1 = '10000' And --TO_CHAR(pha.approved_date,'DD-MON-YYYY') between('16-JAN-2007' AND '17-JAN_2007') AND To_Date(Pha.Approved_Date) Between '15-JAN-2007' And '16-JAN-2007' And Order By Pha.Creation_Date; **Query to Obtain PO/Receipt Select C.Segment1 Po_Number, C.Closed_Code, C.Authorization_Status, D.Line_Num...