XXE4ARW NoetixViews - PO_PO_Distributions

SELECT A$Buyer_Name, A$Buyer_Number, A$Chart_Of_Accounts_Name, A$Deliver_To_Person, A$Deliver_To_Person_Number, A$Destination_Organization, A$Expenditure_Organization, A$Gl_Encumbered_Date, A$Item_Description, A$Ledger_Name, A$Operating_Unit_Name, A$PO_Header_Creation_Date, A$PO_Number, A$Project_Name, A$Project_Number, A$Promised_Date, A$Ship_To_Organization, A$Vendor_Name, Accrual$CV$Accounting_KFF, Accrual$Code_Combination_Id, Accrual$QV$Balancing, Accrual$QV$Cost_Center, Accrual$QV$Natural_Account, Accrual$Segment_Name_List, Accrual$Structure_Name, Accrue_On_Receipt_Flag "Accrue On Receipt Flag", Accrued_Flag "Accrued Flag", AcctAcrl$CV$Accounting_KFF, AcctAcrl$Code_Combination_Id, AcctAcrl$QV$Balancing, AcctAcrl$QV$Cost_Center, AcctAcrl$QV$Natural_Account, AcctAcrl$Segment_Name_List, AcctAcrl$Structure_Name, AcctBdgt$CV$Accounting_KFF, AcctBdgt$Code_Combination_Id, AcctBdgt$QV$Balancing, AcctBdgt$QV$Cost_Center, AcctBdgt$QV$Natural_Account, AcctBdgt$Segment_Name_List, AcctBdgt$Structure_Name, AcctChrg$CV$Accounting_KFF, AcctChrg$Code_Combination_Id, AcctChrg$QV$Balancing, AcctChrg$QV$Cost_Center, AcctChrg$QV$Natural_Account, AcctChrg$SV$Account, AcctChrg$SV$Company, AcctChrg$SV$Cost_Center, AcctChrg$SV$Division_Product, AcctChrg$SV$Site, AcctChrg$Segment_Name_List, AcctChrg$Structure_Name, AcctVar$CV$Accounting_KFF, AcctVar$Code_Combination_Id, AcctVar$QV$Balancing, AcctVar$QV$Cost_Center, AcctVar$QV$Natural_Account, AcctVar$Segment_Name_List, AcctVar$Structure_Name, Amount_Billed "Amount Billed", Amount_Billed_Base "Amount Billed Base", Base_Currency_Code "Base Currency Code", Buyer_Name "Buyer Name", Buyer_Number "Buyer Number", Canceled_Amount "Canceled Amount", Chart_Of_Accounts_Name "Chart Of Accounts Name", Consigned_Flag "Consigned Flag", Deliver_To_Loc_Description "Deliver To Loc Description", Deliver_To_Location "Deliver To Location", Deliver_To_Person "Deliver To Person", Deliver_To_Person_Number "Deliver To Person Number", Delivered_Amount "Delivered Amount", Destination_Organization "Destination Organization", Destination_Subinventory "Destination Subinventory", Destination_Type_Code "Destination Type Code", Distribution_Creation_Date "Distribution Creation Date", Distribution_Number "Distribution Number", Expenditure_Item_Date "Expenditure Item Date", Expenditure_Organization "Expenditure Organization", Gl_Cancelled_Date "Gl Cancelled Date", Gl_Closed_Date "Gl Closed Date", Gl_Encumbered_Date "Gl Encumbered Date", Hazard_Class "Hazard Class", Item$Inventory_Item_Id, Item$Organization_Id, Item$SV$Item, ItemCat$CV$Item_Category_KFF, ItemCat$Category_Id, Item_Description "Item Description", Item_Revision "Item Revision", Ledger_Name "Ledger Name", Need_By_Date "Need By Date", Non_Recoverable_Tax "Non Recoverable Tax", Operating_Unit_Name "Operating Unit Name", Ordered_Amount "Ordered Amount", POHDR$ATTRIBUTE_CATEGORY, POHDR$Business_Unit, POLIN$ATTRIBUTE_CATEGORY, POLIN$Account, POLIN$Area_Code_Description, POLIN$Group, POLIN$Location_No__Location, POLIN$XYAI_Co_Ad_Activity, POLIN$XYAI_Sales_Person, PO_Currency_Code "PO Currency Code", PO_Header_Creation_Date "PO Header Creation Date", PO_Line_Number "PO Line Number", PO_Line_Open_Flag "PO Line Open Flag", PO_Line_Type "PO Line Type", PO_Number "PO Number", PO_Rate "PO Rate", PO_Rate_Date "PO Rate Date", PO_Rate_Type "PO Rate Type", Project_Name "Project Name", Project_Number "Project Number", Promised_Date "Promised Date", Quantity_Billed "Quantity Billed", Quantity_Cancelled "Quantity Cancelled", Quantity_Delivered "Quantity Delivered", Quantity_Ordered "Quantity Ordered", Rate "Rate", Rate_Date "Rate Date", Recoverable_Tax "Recoverable Tax", Recovery_Rate "Recovery Rate", Requisition_Line_Number "Requisition Line Number", Requisition_Number "Requisition Number", Requisition_On_Line_Flag "Requisition On Line Flag", Reserved "Reserved", Set_Of_Books_Name "Set Of Books Name", Ship_To_Organization "Ship To Organization", Shipment_Number "Shipment Number", Shipment_Type "Shipment Type", Task_Name "Task Name", Task_Number "Task Number", Tax_Name "Tax Name", Total_Tax "Total Tax", Unit_Meas_Lookup_Code "Unit Meas Lookup Code", Unit_Price "Unit Price", Unit_Price_Base "Unit Price Base", Vendor_Name "Vendor Name" FROM NOETIX_SYS.POG0_PO_Distributions

SELECT A$Buyer_Name, A$Buyer_Number, A$Chart_Of_Accounts_Name, A$Deliver_To_Person, A$Deliver_To_Person_Number, A$Destination_Organization, A$Expenditure_Organization, A$Gl_Encumbered_Date, A$Item_Description, A$Ledger_Name, A$Operating_Unit_Name, A$PO_Header_Creation_Date, A$PO_Number, A$Project_Name, A$Project_Number, A$Promised_Date, A$Ship_To_Organization, A$Vendor_Name, Accrual$CV$Accounting_KFF, Accrual$Code_Combination_Id, Accrual$QV$Balancing, Accrual$QV$Cost_Center, Accrual$QV$Natural_Account, Accrual$Segment_Name_List, Accrual$Structure_Name, Accrue_On_Receipt_Flag "Accrue On Receipt Flag", Accrued_Flag "Accrued Flag", AcctAcrl$CV$Accounting_KFF, AcctAcrl$Code_Combination_Id, AcctAcrl$QV$Balancing, AcctAcrl$QV$Cost_Center, AcctAcrl$QV$Natural_Account, AcctAcrl$Segment_Name_List, AcctAcrl$Structure_Name, AcctBdgt$CV$Accounting_KFF, AcctBdgt$Code_Combination_Id, AcctBdgt$QV$Balancing, AcctBdgt$QV$Cost_Center, AcctBdgt$QV$Natural_Account, AcctBdgt$Segment_Name_List, AcctBdgt$Structure_Name, AcctChrg$CV$Accounting_KFF, AcctChrg$Code_Combination_Id, AcctChrg$QV$Balancing, AcctChrg$QV$Cost_Center, AcctChrg$QV$Natural_Account, AcctChrg$SV$Account, AcctChrg$SV$Company, AcctChrg$SV$Cost_Center, AcctChrg$SV$Division_Product, AcctChrg$SV$Site, AcctChrg$Segment_Name_List, AcctChrg$Structure_Name, AcctVar$CV$Accounting_KFF, AcctVar$Code_Combination_Id, AcctVar$QV$Balancing, AcctVar$QV$Cost_Center, AcctVar$QV$Natural_Account, AcctVar$Segment_Name_List, AcctVar$Structure_Name, Amount_Billed "Amount Billed", Amount_Billed_Base "Amount Billed Base", Base_Currency_Code "Base Currency Code", Buyer_Name "Buyer Name", Buyer_Number "Buyer Number", Canceled_Amount "Canceled Amount", Chart_Of_Accounts_Name "Chart Of Accounts Name", Consigned_Flag "Consigned Flag", Deliver_To_Loc_Description "Deliver To Loc Description", Deliver_To_Location "Deliver To Location", Deliver_To_Person "Deliver To Person", Deliver_To_Person_Number "Deliver To Person Number", Delivered_Amount "Delivered Amount", Destination_Organization "Destination Organization", Destination_Subinventory "Destination Subinventory", Destination_Type_Code "Destination Type Code", Distribution_Creation_Date "Distribution Creation Date", Distribution_Number "Distribution Number", Expenditure_Item_Date "Expenditure Item Date", Expenditure_Organization "Expenditure Organization", Gl_Cancelled_Date "Gl Cancelled Date", Gl_Closed_Date "Gl Closed Date", Gl_Encumbered_Date "Gl Encumbered Date", Hazard_Class "Hazard Class", Item$Inventory_Item_Id, Item$Organization_Id, Item$SV$Item, ItemCat$CV$Item_Category_KFF, ItemCat$Category_Id, Item_Description "Item Description", Item_Revision "Item Revision", Ledger_Name "Ledger Name", Need_By_Date "Need By Date", Non_Recoverable_Tax "Non Recoverable Tax", Operating_Unit_Name "Operating Unit Name", Ordered_Amount "Ordered Amount", POHDR$ATTRIBUTE_CATEGORY, POHDR$Business_Unit, POLIN$ATTRIBUTE_CATEGORY, POLIN$Account, POLIN$Area_Code_Description, POLIN$Group, POLIN$Location_No__Location, POLIN$XYAI_Co_Ad_Activity, POLIN$XYAI_Sales_Person, PO_Currency_Code "PO Currency Code", PO_Header_Creation_Date "PO Header Creation Date", PO_Line_Number "PO Line Number", PO_Line_Open_Flag "PO Line Open Flag", PO_Line_Type "PO Line Type", PO_Number "PO Number", PO_Rate "PO Rate", PO_Rate_Date "PO Rate Date", PO_Rate_Type "PO Rate Type", Project_Name "Project Name", Project_Number "Project Number", Promised_Date "Promised Date", Quantity_Billed "Quantity Billed", Quantity_Cancelled "Quantity Cancelled", Quantity_Delivered "Quantity Delivered", Quantity_Ordered "Quantity Ordered", Rate "Rate", Rate_Date "Rate Date", Recoverable_Tax "Recoverable Tax", Recovery_Rate "Recovery Rate", Requisition_Line_Number "Requisition Line Number", Requisition_Number "Requisition Number", Requisition_On_Line_Flag "Requisition On Line Flag", Reserved "Reserved", Set_Of_Books_Name "Set Of Books Name", Ship_To_Organization "Ship To Organization", Shipment_Number "Shipment Number", Shipment_Type "Shipment Type", Task_Name "Task Name", Task_Number "Task Number", Tax_Name "Tax Name", Total_Tax "Total Tax", Unit_Meas_Lookup_Code "Unit Meas Lookup Code", Unit_Price "Unit Price", Unit_Price_Base "Unit Price Base", Vendor_Name "Vendor Name" FROM NOETIX_SYS.POG0_PO_Distributions