eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PO_LINE_LOCATIONS_MERGE_V

Source

View Text - Preformatted


SELECT Dft.Owner_User_Id , Dft.Owner_Role , Dft.Status , Dft.Draft_Id , Plld.Change_Accepted_Flag , Plld.Delete_Flag , Plld.Ussgl_Transaction_Code , Plld.Government_Context , Plld.Receiving_Routing_Id , Plld.Accrue_On_Receipt_Flag , Plld.Closed_Reason , Plld.Closed_Date , Plld.Closed_By , Plld.Org_Id , Plld.Attribute6 , Plld.Attribute7 , Plld.Attribute8 , Plld.Attribute9 , Plld.Attribute10 , Plld.Unit_Of_Measure_Class , Plld.Encumber_Now , Plld.Attribute11 , Plld.Attribute12 , Plld.Attribute13 , Plld.Attribute14 , Plld.Attribute15 , Plld.Inspection_Required_Flag , Plld.Receipt_Required_Flag , Plld.Qty_Rcv_Tolerance , Plld.Qty_Rcv_Exception_Code , Plld.Enforce_Ship_To_Location_Code , Plld.Allow_Substitute_Receipts_Flag, Plld.Days_Early_Receipt_Allowed , Plld.Days_Late_Receipt_Allowed , Plld.Receipt_Days_Exception_Code , Plld.Invoice_Close_Tolerance , Plld.Receive_Close_Tolerance , Plld.Ship_To_Organization_Id , Plld.Shipment_Num , Plld.Source_Shipment_Id , Plld.Shipment_Type , Plld.Closed_Code , Plld.Request_Id , Plld.Program_Application_Id , Plld.Program_Id , Plld.Program_Update_Date , Plld.Promised_Date , Plld.Last_Accept_Date , Plld.Price_Override , Plld.Encumbered_Flag , Plld.Encumbered_Date , Plld.Unencumbered_Quantity , Plld.Fob_Lookup_Code , Plld.Freight_Terms_Lookup_Code , Plld.Taxable_Flag , Plld.Estimated_Tax_Amount , Plld.From_Header_Id , Plld.From_Line_Id , Plld.From_Line_Location_Id , Plld.Start_Date , Plld.End_Date , Plld.Lead_Time , Plld.Lead_Time_Unit , Plld.Price_Discount , Plld.Terms_Id , Plld.Approved_Flag , Plld.Approved_Date , Plld.Closed_Flag , Plld.Cancel_Flag , Plld.Cancelled_By , Plld.Cancel_Date , Plld.Cancel_Reason , Plld.Firm_Status_Lookup_Code , Plld.Firm_Date , Plld.Attribute_Category , Plld.Attribute1 , Plld.Attribute2 , Plld.Attribute3 , Plld.Attribute4 , Plld.Attribute5 , Plld.Line_Location_Id , Plld.Last_Update_Date , Plld.Last_Updated_By , Plld.Po_Header_Id , Plld.Po_Line_Id , Plld.Last_Update_Login , Plld.Creation_Date , Plld.Created_By , Plld.Quantity , Plld.Quantity_Received , Plld.Quantity_Accepted , Plld.Quantity_Rejected , Plld.Quantity_Billed , Plld.Quantity_Cancelled , Plld.Unit_Meas_Lookup_Code , Plld.Po_Release_Id , Plld.Ship_To_Location_Id , Plld.Ship_Via_Lookup_Code , Plld.Need_By_Date , Plld.Global_Attribute_Category , Plld.Global_Attribute1 , Plld.Global_Attribute2 , Plld.Global_Attribute3 , Plld.Global_Attribute4 , Plld.Global_Attribute5 , Plld.Global_Attribute6 , Plld.Global_Attribute7 , Plld.Global_Attribute8 , Plld.Global_Attribute9 , Plld.Global_Attribute10 , Plld.Global_Attribute11 , Plld.Global_Attribute12 , Plld.Global_Attribute13 , Plld.Global_Attribute14 , Plld.Global_Attribute15 , Plld.Global_Attribute16 , Plld.Global_Attribute17 , Plld.Global_Attribute18 , Plld.Global_Attribute19 , Plld.Global_Attribute20 , Plld.Quantity_Shipped , Plld.Country_Of_Origin_Code , Plld.Tax_User_Override_Flag , Plld.Match_Option , Plld.Tax_Code_Id , Plld.Calculate_Tax_Flag , Plld.Change_Promised_Date_Reason , Plld.Note_To_Receiver , Plld.Secondary_Unit_Of_Measure , Plld.Secondary_Quantity , Plld.Preferred_Grade , Plld.Secondary_Quantity_Received , Plld.Secondary_Quantity_Accepted , Plld.Secondary_Quantity_Rejected , Plld.Secondary_Quantity_Cancelled , Plld.Vmi_Flag , Plld.Consigned_Flag , Plld.Retroactive_Date , Plld.Supplier_Order_Line_Number , Plld.Amount , Plld.Amount_Received , Plld.Amount_Billed , Plld.Amount_Cancelled , Plld.Amount_Accepted , Plld.Amount_Rejected , Plld.Drop_Ship_Flag , Plld.Sales_Order_Update_Date , Plld.Transaction_Flow_Header_Id , Plld.Final_Match_Flag , Plld.Manual_Price_Change_Flag , Plld.Shipment_Closed_Date , Plld.Closed_For_Receiving_Date , Plld.Closed_For_Invoice_Date , Plld.Secondary_Quantity_Shipped , Plld.Value_Basis , Plld.Matching_Basis , Plld.Payment_Type , Plld.Description , Plld.Work_Approver_Id , Plld.Bid_Payment_Id , Plld.Quantity_Financed , Plld.Amount_Financed , Plld.Quantity_Recouped , Plld.Amount_Recouped , Plld.Retainage_Withheld_Amount , Plld.Retainage_Released_Amount , Plld.Amount_Shipped , Plld.Tax_Attribute_Update_Code , Plld.Outsourced_Assembly , Plld.Tax_Name , Plld.Control_Action , Plld.Change_Status , Plld.uda_template_id, Plld.clm_period_perf_end_date, Plld.clm_period_perf_start_date, Plld.old_quantity, Plld.clm_delivery_period, Plld.clm_promise_period, Plld.clm_pop_duration, Plld.clm_delivery_period_uom, Plld.clm_promise_period_uom, Plld.clm_pop_duration_uom, Plld.comments FROM PO_LINE_LOCATIONS_DRAFT_ALL PLLD,PO_DRAFTS DFT WHERE Plld.Draft_Id = Dft.Draft_Id And Nvl(Plld.Delete_Flag,'N') = 'N' Union All Select To_Number(Null), Null, Null, To_Number(-1), Null, Null, Pll.Ussgl_Transaction_Code, Pll.Government_Context, Pll.Receiving_Routing_Id, Pll.Accrue_On_Receipt_Flag, Pll.Closed_Reason, Pll.Closed_Date, Pll.Closed_By, Pll.Org_Id, Pll.Attribute6, Pll.Attribute7, Pll.Attribute8, Pll.Attribute9, Pll.Attribute10, Pll.Unit_Of_Measure_Class, Pll.Encumber_Now, Pll.Attribute11, Pll.Attribute12, Pll.Attribute13, Pll.Attribute14, Pll.Attribute15, Pll.Inspection_Required_Flag, Pll.Receipt_Required_Flag, Pll.Qty_Rcv_Tolerance, Pll.Qty_Rcv_Exception_Code, Pll.Enforce_Ship_To_Location_Code, Pll.Allow_Substitute_Receipts_Flag, Pll.Days_Early_Receipt_Allowed, Pll.Days_Late_Receipt_Allowed, Pll.Receipt_Days_Exception_Code, Pll.Invoice_Close_Tolerance, Pll.Receive_Close_Tolerance, Pll.Ship_To_Organization_Id, Pll.Shipment_Num, Pll.Source_Shipment_Id, Pll.Shipment_Type, Pll.Closed_Code, Pll.Request_Id, Pll.Program_Application_Id, Pll.Program_Id, Pll.Program_Update_Date, Pll.Promised_Date, Pll.Last_Accept_Date, Pll.Price_Override, Pll.Encumbered_Flag, Pll.Encumbered_Date, Pll.Unencumbered_Quantity, Pll.Fob_Lookup_Code, Pll.Freight_Terms_Lookup_Code, Pll.Taxable_Flag, Pll.Estimated_Tax_Amount, Pll.From_Header_Id, Pll.From_Line_Id, Pll.From_Line_Location_Id, Pll.Start_Date, Pll.End_Date, Pll.Lead_Time, Pll.Lead_Time_Unit, Pll.Price_Discount, Pll.Terms_Id, Pll.Approved_Flag, Pll.Approved_Date, Pll.Closed_Flag, Pll.Cancel_Flag, Pll.Cancelled_By, Pll.Cancel_Date, Pll.Cancel_Reason, Pll.Firm_Status_Lookup_Code, Pll.Firm_Date, Pll.Attribute_Category, Pll.Attribute1, Pll.Attribute2, Pll.Attribute3, Pll.Attribute4, Pll.Attribute5, Pll.Line_Location_Id, Pll.Last_Update_Date, Pll.Last_Updated_By, Pll.Po_Header_Id, Pll.Po_Line_Id, Pll.Last_Update_Login, Pll.Creation_Date, Pll.Created_By, Pll.Quantity, Pll.Quantity_Received, Pll.Quantity_Accepted, Pll.Quantity_Rejected, Pll.Quantity_Billed, Pll.Quantity_Cancelled, Pll.Unit_Meas_Lookup_Code, Pll.Po_Release_Id, Pll.Ship_To_Location_Id, Pll.Ship_Via_Lookup_Code, Pll.Need_By_Date, Pll.Global_Attribute_Category, Pll.Global_Attribute1, Pll.Global_Attribute2, Pll.Global_Attribute3, Pll.Global_Attribute4, Pll.Global_Attribute5, Pll.Global_Attribute6, Pll.Global_Attribute7, Pll.Global_Attribute8, Pll.Global_Attribute9, Pll.Global_Attribute10, Pll.Global_Attribute11, Pll.Global_Attribute12, Pll.Global_Attribute13, Pll.Global_Attribute14, Pll.Global_Attribute15, Pll.Global_Attribute16, Pll.Global_Attribute17, Pll.Global_Attribute18, Pll.Global_Attribute19, Pll.Global_Attribute20, Pll.Quantity_Shipped, Pll.Country_Of_Origin_Code, Pll.Tax_User_Override_Flag, Pll.Match_Option, Pll.Tax_Code_Id, Pll.Calculate_Tax_Flag, Pll.Change_Promised_Date_Reason, Pll.Note_To_Receiver, Pll.Secondary_Unit_Of_Measure, Pll.Secondary_Quantity, Pll.Preferred_Grade, Pll.Secondary_Quantity_Received, Pll.Secondary_Quantity_Accepted, Pll.Secondary_Quantity_Rejected, Pll.Secondary_Quantity_Cancelled, Pll.Vmi_Flag, Pll.Consigned_Flag, Pll.Retroactive_Date, Pll.Supplier_Order_Line_Number, Pll.Amount, Pll.Amount_Received, Pll.Amount_Billed, Pll.Amount_Cancelled, Pll.Amount_Accepted, Pll.Amount_Rejected, Pll.Drop_Ship_Flag, Pll.Sales_Order_Update_Date, Pll.Transaction_Flow_Header_Id, Pll.Final_Match_Flag, Pll.Manual_Price_Change_Flag, Pll.Shipment_Closed_Date, Pll.Closed_For_Receiving_Date, Pll.Closed_For_Invoice_Date, Pll.Secondary_Quantity_Shipped, Pll.Value_Basis, Pll.Matching_Basis, Pll.Payment_Type, Pll.Description, Pll.Work_Approver_Id, Pll.Bid_Payment_Id, Pll.Quantity_Financed, Pll.Amount_Financed, Pll.Quantity_Recouped, Pll.Amount_Recouped, Pll.Retainage_Withheld_Amount, Pll.Retainage_Released_Amount, Pll.Amount_Shipped, Pll.Tax_Attribute_Update_Code, Pll.Outsourced_Assembly, Pll.Tax_Name, Null, NULL, Pll.uda_template_id, Pll.clm_period_perf_end_date,Pll.clm_period_perf_start_date, pll.quantity, Pll.clm_delivery_period, Pll.clm_promise_period, Pll.clm_pop_duration, Pll.clm_delivery_period_uom, Pll.clm_promise_period_uom, Pll.clm_pop_duration_uom, null From Po_Line_Locations_All Pll Union All Select To_Number(Null), Null, Null, Dft.Draft_Id, Null, Null, Pll.Ussgl_Transaction_Code, Pll.Government_Context, Pll.Receiving_Routing_Id, Pll.Accrue_On_Receipt_Flag, Pll.Closed_Reason, Pll.Closed_Date, Pll.Closed_By, Pll.Org_Id, Pll.Attribute6, Pll.Attribute7, Pll.Attribute8, Pll.Attribute9, Pll.Attribute10, Pll.Unit_Of_Measure_Class, Pll.Encumber_Now, Pll.Attribute11, Pll.Attribute12, Pll.Attribute13, Pll.Attribute14, Pll.Attribute15, Pll.Inspection_Required_Flag, Pll.Receipt_Required_Flag, Pll.Qty_Rcv_Tolerance, Pll.Qty_Rcv_Exception_Code, Pll.Enforce_Ship_To_Location_Code, Pll.Allow_Substitute_Receipts_Flag, Pll.Days_Early_Receipt_Allowed, Pll.Days_Late_Receipt_Allowed, Pll.Receipt_Days_Exception_Code, Pll.Invoice_Close_Tolerance, Pll.Receive_Close_Tolerance, Pll.Ship_To_Organization_Id, Pll.Shipment_Num, Pll.Source_Shipment_Id, Pll.Shipment_Type, Pll.Closed_Code, Pll.Request_Id, Pll.Program_Application_Id, Pll.Program_Id, Pll.Program_Update_Date, Pll.Promised_Date, Pll.Last_Accept_Date, Pll.Price_Override, Pll.Encumbered_Flag, Pll.Encumbered_Date, Pll.Unencumbered_Quantity, Pll.Fob_Lookup_Code, Pll.Freight_Terms_Lookup_Code, Pll.Taxable_Flag, Pll.Estimated_Tax_Amount, Pll.From_Header_Id, Pll.From_Line_Id, Pll.From_Line_Location_Id, Pll.Start_Date, Pll.End_Date, Pll.Lead_Time, Pll.Lead_Time_Unit, Pll.Price_Discount, Pll.Terms_Id, Pll.Approved_Flag, Pll.Approved_Date, Pll.Closed_Flag, Pll.Cancel_Flag, Pll.Cancelled_By, Pll.Cancel_Date, Pll.Cancel_Reason, Pll.Firm_Status_Lookup_Code, Pll.Firm_Date, Pll.Attribute_Category, Pll.Attribute1, Pll.Attribute2, Pll.Attribute3, Pll.Attribute4, Pll.Attribute5, Pll.Line_Location_Id, Pll.Last_Update_Date, Pll.Last_Updated_By, Pll.Po_Header_Id, Pll.Po_Line_Id, Pll.Last_Update_Login, Pll.Creation_Date, Pll.Created_By, Pll.Quantity, Pll.Quantity_Received, Pll.Quantity_Accepted, Pll.Quantity_Rejected, Pll.Quantity_Billed, Pll.Quantity_Cancelled, Pll.Unit_Meas_Lookup_Code, Pll.Po_Release_Id, Pll.Ship_To_Location_Id, Pll.Ship_Via_Lookup_Code, Pll.Need_By_Date, Pll.Global_Attribute_Category, Pll.Global_Attribute1, Pll.Global_Attribute2, Pll.Global_Attribute3, Pll.Global_Attribute4, Pll.Global_Attribute5, Pll.Global_Attribute6, Pll.Global_Attribute7, Pll.Global_Attribute8, Pll.Global_Attribute9, Pll.Global_Attribute10, Pll.Global_Attribute11, Pll.Global_Attribute12, Pll.Global_Attribute13, Pll.Global_Attribute14, Pll.Global_Attribute15, Pll.Global_Attribute16, Pll.Global_Attribute17, Pll.Global_Attribute18, Pll.Global_Attribute19, Pll.Global_Attribute20, Pll.Quantity_Shipped, Pll.Country_Of_Origin_Code, Pll.Tax_User_Override_Flag, Pll.Match_Option, Pll.Tax_Code_Id, Pll.Calculate_Tax_Flag, Pll.Change_Promised_Date_Reason, Pll.Note_To_Receiver, Pll.Secondary_Unit_Of_Measure, Pll.Secondary_Quantity, Pll.Preferred_Grade, Pll.Secondary_Quantity_Received, Pll.Secondary_Quantity_Accepted, Pll.Secondary_Quantity_Rejected, Pll.Secondary_Quantity_Cancelled, Pll.Vmi_Flag, Pll.Consigned_Flag, Pll.Retroactive_Date, Pll.Supplier_Order_Line_Number, Pll.Amount, Pll.Amount_Received, Pll.Amount_Billed, Pll.Amount_Cancelled, Pll.Amount_Accepted, Pll.Amount_Rejected, Pll.Drop_Ship_Flag, Pll.Sales_Order_Update_Date, Pll.Transaction_Flow_Header_Id, Pll.Final_Match_Flag, Pll.Manual_Price_Change_Flag, Pll.Shipment_Closed_Date, Pll.Closed_For_Receiving_Date, Pll.Closed_For_Invoice_Date, Pll.Secondary_Quantity_Shipped, Pll.Value_Basis, Pll.Matching_Basis, Pll.Payment_Type, Pll.Description, Pll.Work_Approver_Id, Pll.Bid_Payment_Id, Pll.Quantity_Financed, Pll.Amount_Financed, Pll.Quantity_Recouped, Pll.Amount_Recouped, Pll.Retainage_Withheld_Amount, Pll.Retainage_Released_Amount, Pll.Amount_Shipped, Pll.Tax_Attribute_Update_Code, Pll.Outsourced_Assembly, Pll.Tax_Name, Null, NULL, Pll.uda_template_id,Pll.clm_period_perf_end_date,Pll.clm_period_perf_start_date, pll.quantity, Pll.clm_delivery_period, Pll.clm_promise_period, Pll.clm_pop_duration, Pll.clm_delivery_period_uom, Pll.clm_promise_period_uom, Pll.clm_pop_duration_uom, null From Po_Line_Locations_All Pll, Po_Drafts Dft Where Pll.Po_Header_Id = Dft.Document_Id And Not Exists (Select 'Draft Exists For This Shipment' From Po_Line_Locations_Draft_All Plld Where Pll.Line_Location_Id = Plld.Line_Location_Id And Plld.Draft_Id = Dft.Draft_Id And Nvl(Plld.Delete_Flag,'N') = 'N')

View Text - HTML Formatted

SELECT DFT.OWNER_USER_ID
, DFT.OWNER_ROLE
, DFT.STATUS
, DFT.DRAFT_ID
, PLLD.CHANGE_ACCEPTED_FLAG
, PLLD.DELETE_FLAG
, PLLD.USSGL_TRANSACTION_CODE
, PLLD.GOVERNMENT_CONTEXT
, PLLD.RECEIVING_ROUTING_ID
, PLLD.ACCRUE_ON_RECEIPT_FLAG
, PLLD.CLOSED_REASON
, PLLD.CLOSED_DATE
, PLLD.CLOSED_BY
, PLLD.ORG_ID
, PLLD.ATTRIBUTE6
, PLLD.ATTRIBUTE7
, PLLD.ATTRIBUTE8
, PLLD.ATTRIBUTE9
, PLLD.ATTRIBUTE10
, PLLD.UNIT_OF_MEASURE_CLASS
, PLLD.ENCUMBER_NOW
, PLLD.ATTRIBUTE11
, PLLD.ATTRIBUTE12
, PLLD.ATTRIBUTE13
, PLLD.ATTRIBUTE14
, PLLD.ATTRIBUTE15
, PLLD.INSPECTION_REQUIRED_FLAG
, PLLD.RECEIPT_REQUIRED_FLAG
, PLLD.QTY_RCV_TOLERANCE
, PLLD.QTY_RCV_EXCEPTION_CODE
, PLLD.ENFORCE_SHIP_TO_LOCATION_CODE
, PLLD.ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, PLLD.DAYS_EARLY_RECEIPT_ALLOWED
, PLLD.DAYS_LATE_RECEIPT_ALLOWED
, PLLD.RECEIPT_DAYS_EXCEPTION_CODE
, PLLD.INVOICE_CLOSE_TOLERANCE
, PLLD.RECEIVE_CLOSE_TOLERANCE
, PLLD.SHIP_TO_ORGANIZATION_ID
, PLLD.SHIPMENT_NUM
, PLLD.SOURCE_SHIPMENT_ID
, PLLD.SHIPMENT_TYPE
, PLLD.CLOSED_CODE
, PLLD.REQUEST_ID
, PLLD.PROGRAM_APPLICATION_ID
, PLLD.PROGRAM_ID
, PLLD.PROGRAM_UPDATE_DATE
, PLLD.PROMISED_DATE
, PLLD.LAST_ACCEPT_DATE
, PLLD.PRICE_OVERRIDE
, PLLD.ENCUMBERED_FLAG
, PLLD.ENCUMBERED_DATE
, PLLD.UNENCUMBERED_QUANTITY
, PLLD.FOB_LOOKUP_CODE
, PLLD.FREIGHT_TERMS_LOOKUP_CODE
, PLLD.TAXABLE_FLAG
, PLLD.ESTIMATED_TAX_AMOUNT
, PLLD.FROM_HEADER_ID
, PLLD.FROM_LINE_ID
, PLLD.FROM_LINE_LOCATION_ID
, PLLD.START_DATE
, PLLD.END_DATE
, PLLD.LEAD_TIME
, PLLD.LEAD_TIME_UNIT
, PLLD.PRICE_DISCOUNT
, PLLD.TERMS_ID
, PLLD.APPROVED_FLAG
, PLLD.APPROVED_DATE
, PLLD.CLOSED_FLAG
, PLLD.CANCEL_FLAG
, PLLD.CANCELLED_BY
, PLLD.CANCEL_DATE
, PLLD.CANCEL_REASON
, PLLD.FIRM_STATUS_LOOKUP_CODE
, PLLD.FIRM_DATE
, PLLD.ATTRIBUTE_CATEGORY
, PLLD.ATTRIBUTE1
, PLLD.ATTRIBUTE2
, PLLD.ATTRIBUTE3
, PLLD.ATTRIBUTE4
, PLLD.ATTRIBUTE5
, PLLD.LINE_LOCATION_ID
, PLLD.LAST_UPDATE_DATE
, PLLD.LAST_UPDATED_BY
, PLLD.PO_HEADER_ID
, PLLD.PO_LINE_ID
, PLLD.LAST_UPDATE_LOGIN
, PLLD.CREATION_DATE
, PLLD.CREATED_BY
, PLLD.QUANTITY
, PLLD.QUANTITY_RECEIVED
, PLLD.QUANTITY_ACCEPTED
, PLLD.QUANTITY_REJECTED
, PLLD.QUANTITY_BILLED
, PLLD.QUANTITY_CANCELLED
, PLLD.UNIT_MEAS_LOOKUP_CODE
, PLLD.PO_RELEASE_ID
, PLLD.SHIP_TO_LOCATION_ID
, PLLD.SHIP_VIA_LOOKUP_CODE
, PLLD.NEED_BY_DATE
, PLLD.GLOBAL_ATTRIBUTE_CATEGORY
, PLLD.GLOBAL_ATTRIBUTE1
, PLLD.GLOBAL_ATTRIBUTE2
, PLLD.GLOBAL_ATTRIBUTE3
, PLLD.GLOBAL_ATTRIBUTE4
, PLLD.GLOBAL_ATTRIBUTE5
, PLLD.GLOBAL_ATTRIBUTE6
, PLLD.GLOBAL_ATTRIBUTE7
, PLLD.GLOBAL_ATTRIBUTE8
, PLLD.GLOBAL_ATTRIBUTE9
, PLLD.GLOBAL_ATTRIBUTE10
, PLLD.GLOBAL_ATTRIBUTE11
, PLLD.GLOBAL_ATTRIBUTE12
, PLLD.GLOBAL_ATTRIBUTE13
, PLLD.GLOBAL_ATTRIBUTE14
, PLLD.GLOBAL_ATTRIBUTE15
, PLLD.GLOBAL_ATTRIBUTE16
, PLLD.GLOBAL_ATTRIBUTE17
, PLLD.GLOBAL_ATTRIBUTE18
, PLLD.GLOBAL_ATTRIBUTE19
, PLLD.GLOBAL_ATTRIBUTE20
, PLLD.QUANTITY_SHIPPED
, PLLD.COUNTRY_OF_ORIGIN_CODE
, PLLD.TAX_USER_OVERRIDE_FLAG
, PLLD.MATCH_OPTION
, PLLD.TAX_CODE_ID
, PLLD.CALCULATE_TAX_FLAG
, PLLD.CHANGE_PROMISED_DATE_REASON
, PLLD.NOTE_TO_RECEIVER
, PLLD.SECONDARY_UNIT_OF_MEASURE
, PLLD.SECONDARY_QUANTITY
, PLLD.PREFERRED_GRADE
, PLLD.SECONDARY_QUANTITY_RECEIVED
, PLLD.SECONDARY_QUANTITY_ACCEPTED
, PLLD.SECONDARY_QUANTITY_REJECTED
, PLLD.SECONDARY_QUANTITY_CANCELLED
, PLLD.VMI_FLAG
, PLLD.CONSIGNED_FLAG
, PLLD.RETROACTIVE_DATE
, PLLD.SUPPLIER_ORDER_LINE_NUMBER
, PLLD.AMOUNT
, PLLD.AMOUNT_RECEIVED
, PLLD.AMOUNT_BILLED
, PLLD.AMOUNT_CANCELLED
, PLLD.AMOUNT_ACCEPTED
, PLLD.AMOUNT_REJECTED
, PLLD.DROP_SHIP_FLAG
, PLLD.SALES_ORDER_UPDATE_DATE
, PLLD.TRANSACTION_FLOW_HEADER_ID
, PLLD.FINAL_MATCH_FLAG
, PLLD.MANUAL_PRICE_CHANGE_FLAG
, PLLD.SHIPMENT_CLOSED_DATE
, PLLD.CLOSED_FOR_RECEIVING_DATE
, PLLD.CLOSED_FOR_INVOICE_DATE
, PLLD.SECONDARY_QUANTITY_SHIPPED
, PLLD.VALUE_BASIS
, PLLD.MATCHING_BASIS
, PLLD.PAYMENT_TYPE
, PLLD.DESCRIPTION
, PLLD.WORK_APPROVER_ID
, PLLD.BID_PAYMENT_ID
, PLLD.QUANTITY_FINANCED
, PLLD.AMOUNT_FINANCED
, PLLD.QUANTITY_RECOUPED
, PLLD.AMOUNT_RECOUPED
, PLLD.RETAINAGE_WITHHELD_AMOUNT
, PLLD.RETAINAGE_RELEASED_AMOUNT
, PLLD.AMOUNT_SHIPPED
, PLLD.TAX_ATTRIBUTE_UPDATE_CODE
, PLLD.OUTSOURCED_ASSEMBLY
, PLLD.TAX_NAME
, PLLD.CONTROL_ACTION
, PLLD.CHANGE_STATUS
, PLLD.UDA_TEMPLATE_ID
, PLLD.CLM_PERIOD_PERF_END_DATE
, PLLD.CLM_PERIOD_PERF_START_DATE
, PLLD.OLD_QUANTITY
, PLLD.CLM_DELIVERY_PERIOD
, PLLD.CLM_PROMISE_PERIOD
, PLLD.CLM_POP_DURATION
, PLLD.CLM_DELIVERY_PERIOD_UOM
, PLLD.CLM_PROMISE_PERIOD_UOM
, PLLD.CLM_POP_DURATION_UOM
, PLLD.COMMENTS
FROM PO_LINE_LOCATIONS_DRAFT_ALL PLLD
, PO_DRAFTS DFT
WHERE PLLD.DRAFT_ID = DFT.DRAFT_ID
AND NVL(PLLD.DELETE_FLAG
, 'N') = 'N' UNION ALL SELECT TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(-1)
, NULL
, NULL
, PLL.USSGL_TRANSACTION_CODE
, PLL.GOVERNMENT_CONTEXT
, PLL.RECEIVING_ROUTING_ID
, PLL.ACCRUE_ON_RECEIPT_FLAG
, PLL.CLOSED_REASON
, PLL.CLOSED_DATE
, PLL.CLOSED_BY
, PLL.ORG_ID
, PLL.ATTRIBUTE6
, PLL.ATTRIBUTE7
, PLL.ATTRIBUTE8
, PLL.ATTRIBUTE9
, PLL.ATTRIBUTE10
, PLL.UNIT_OF_MEASURE_CLASS
, PLL.ENCUMBER_NOW
, PLL.ATTRIBUTE11
, PLL.ATTRIBUTE12
, PLL.ATTRIBUTE13
, PLL.ATTRIBUTE14
, PLL.ATTRIBUTE15
, PLL.INSPECTION_REQUIRED_FLAG
, PLL.RECEIPT_REQUIRED_FLAG
, PLL.QTY_RCV_TOLERANCE
, PLL.QTY_RCV_EXCEPTION_CODE
, PLL.ENFORCE_SHIP_TO_LOCATION_CODE
, PLL.ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, PLL.DAYS_EARLY_RECEIPT_ALLOWED
, PLL.DAYS_LATE_RECEIPT_ALLOWED
, PLL.RECEIPT_DAYS_EXCEPTION_CODE
, PLL.INVOICE_CLOSE_TOLERANCE
, PLL.RECEIVE_CLOSE_TOLERANCE
, PLL.SHIP_TO_ORGANIZATION_ID
, PLL.SHIPMENT_NUM
, PLL.SOURCE_SHIPMENT_ID
, PLL.SHIPMENT_TYPE
, PLL.CLOSED_CODE
, PLL.REQUEST_ID
, PLL.PROGRAM_APPLICATION_ID
, PLL.PROGRAM_ID
, PLL.PROGRAM_UPDATE_DATE
, PLL.PROMISED_DATE
, PLL.LAST_ACCEPT_DATE
, PLL.PRICE_OVERRIDE
, PLL.ENCUMBERED_FLAG
, PLL.ENCUMBERED_DATE
, PLL.UNENCUMBERED_QUANTITY
, PLL.FOB_LOOKUP_CODE
, PLL.FREIGHT_TERMS_LOOKUP_CODE
, PLL.TAXABLE_FLAG
, PLL.ESTIMATED_TAX_AMOUNT
, PLL.FROM_HEADER_ID
, PLL.FROM_LINE_ID
, PLL.FROM_LINE_LOCATION_ID
, PLL.START_DATE
, PLL.END_DATE
, PLL.LEAD_TIME
, PLL.LEAD_TIME_UNIT
, PLL.PRICE_DISCOUNT
, PLL.TERMS_ID
, PLL.APPROVED_FLAG
, PLL.APPROVED_DATE
, PLL.CLOSED_FLAG
, PLL.CANCEL_FLAG
, PLL.CANCELLED_BY
, PLL.CANCEL_DATE
, PLL.CANCEL_REASON
, PLL.FIRM_STATUS_LOOKUP_CODE
, PLL.FIRM_DATE
, PLL.ATTRIBUTE_CATEGORY
, PLL.ATTRIBUTE1
, PLL.ATTRIBUTE2
, PLL.ATTRIBUTE3
, PLL.ATTRIBUTE4
, PLL.ATTRIBUTE5
, PLL.LINE_LOCATION_ID
, PLL.LAST_UPDATE_DATE
, PLL.LAST_UPDATED_BY
, PLL.PO_HEADER_ID
, PLL.PO_LINE_ID
, PLL.LAST_UPDATE_LOGIN
, PLL.CREATION_DATE
, PLL.CREATED_BY
, PLL.QUANTITY
, PLL.QUANTITY_RECEIVED
, PLL.QUANTITY_ACCEPTED
, PLL.QUANTITY_REJECTED
, PLL.QUANTITY_BILLED
, PLL.QUANTITY_CANCELLED
, PLL.UNIT_MEAS_LOOKUP_CODE
, PLL.PO_RELEASE_ID
, PLL.SHIP_TO_LOCATION_ID
, PLL.SHIP_VIA_LOOKUP_CODE
, PLL.NEED_BY_DATE
, PLL.GLOBAL_ATTRIBUTE_CATEGORY
, PLL.GLOBAL_ATTRIBUTE1
, PLL.GLOBAL_ATTRIBUTE2
, PLL.GLOBAL_ATTRIBUTE3
, PLL.GLOBAL_ATTRIBUTE4
, PLL.GLOBAL_ATTRIBUTE5
, PLL.GLOBAL_ATTRIBUTE6
, PLL.GLOBAL_ATTRIBUTE7
, PLL.GLOBAL_ATTRIBUTE8
, PLL.GLOBAL_ATTRIBUTE9
, PLL.GLOBAL_ATTRIBUTE10
, PLL.GLOBAL_ATTRIBUTE11
, PLL.GLOBAL_ATTRIBUTE12
, PLL.GLOBAL_ATTRIBUTE13
, PLL.GLOBAL_ATTRIBUTE14
, PLL.GLOBAL_ATTRIBUTE15
, PLL.GLOBAL_ATTRIBUTE16
, PLL.GLOBAL_ATTRIBUTE17
, PLL.GLOBAL_ATTRIBUTE18
, PLL.GLOBAL_ATTRIBUTE19
, PLL.GLOBAL_ATTRIBUTE20
, PLL.QUANTITY_SHIPPED
, PLL.COUNTRY_OF_ORIGIN_CODE
, PLL.TAX_USER_OVERRIDE_FLAG
, PLL.MATCH_OPTION
, PLL.TAX_CODE_ID
, PLL.CALCULATE_TAX_FLAG
, PLL.CHANGE_PROMISED_DATE_REASON
, PLL.NOTE_TO_RECEIVER
, PLL.SECONDARY_UNIT_OF_MEASURE
, PLL.SECONDARY_QUANTITY
, PLL.PREFERRED_GRADE
, PLL.SECONDARY_QUANTITY_RECEIVED
, PLL.SECONDARY_QUANTITY_ACCEPTED
, PLL.SECONDARY_QUANTITY_REJECTED
, PLL.SECONDARY_QUANTITY_CANCELLED
, PLL.VMI_FLAG
, PLL.CONSIGNED_FLAG
, PLL.RETROACTIVE_DATE
, PLL.SUPPLIER_ORDER_LINE_NUMBER
, PLL.AMOUNT
, PLL.AMOUNT_RECEIVED
, PLL.AMOUNT_BILLED
, PLL.AMOUNT_CANCELLED
, PLL.AMOUNT_ACCEPTED
, PLL.AMOUNT_REJECTED
, PLL.DROP_SHIP_FLAG
, PLL.SALES_ORDER_UPDATE_DATE
, PLL.TRANSACTION_FLOW_HEADER_ID
, PLL.FINAL_MATCH_FLAG
, PLL.MANUAL_PRICE_CHANGE_FLAG
, PLL.SHIPMENT_CLOSED_DATE
, PLL.CLOSED_FOR_RECEIVING_DATE
, PLL.CLOSED_FOR_INVOICE_DATE
, PLL.SECONDARY_QUANTITY_SHIPPED
, PLL.VALUE_BASIS
, PLL.MATCHING_BASIS
, PLL.PAYMENT_TYPE
, PLL.DESCRIPTION
, PLL.WORK_APPROVER_ID
, PLL.BID_PAYMENT_ID
, PLL.QUANTITY_FINANCED
, PLL.AMOUNT_FINANCED
, PLL.QUANTITY_RECOUPED
, PLL.AMOUNT_RECOUPED
, PLL.RETAINAGE_WITHHELD_AMOUNT
, PLL.RETAINAGE_RELEASED_AMOUNT
, PLL.AMOUNT_SHIPPED
, PLL.TAX_ATTRIBUTE_UPDATE_CODE
, PLL.OUTSOURCED_ASSEMBLY
, PLL.TAX_NAME
, NULL
, NULL
, PLL.UDA_TEMPLATE_ID
, PLL.CLM_PERIOD_PERF_END_DATE
, PLL.CLM_PERIOD_PERF_START_DATE
, PLL.QUANTITY
, PLL.CLM_DELIVERY_PERIOD
, PLL.CLM_PROMISE_PERIOD
, PLL.CLM_POP_DURATION
, PLL.CLM_DELIVERY_PERIOD_UOM
, PLL.CLM_PROMISE_PERIOD_UOM
, PLL.CLM_POP_DURATION_UOM
, NULL
FROM PO_LINE_LOCATIONS_ALL PLL UNION ALL SELECT TO_NUMBER(NULL)
, NULL
, NULL
, DFT.DRAFT_ID
, NULL
, NULL
, PLL.USSGL_TRANSACTION_CODE
, PLL.GOVERNMENT_CONTEXT
, PLL.RECEIVING_ROUTING_ID
, PLL.ACCRUE_ON_RECEIPT_FLAG
, PLL.CLOSED_REASON
, PLL.CLOSED_DATE
, PLL.CLOSED_BY
, PLL.ORG_ID
, PLL.ATTRIBUTE6
, PLL.ATTRIBUTE7
, PLL.ATTRIBUTE8
, PLL.ATTRIBUTE9
, PLL.ATTRIBUTE10
, PLL.UNIT_OF_MEASURE_CLASS
, PLL.ENCUMBER_NOW
, PLL.ATTRIBUTE11
, PLL.ATTRIBUTE12
, PLL.ATTRIBUTE13
, PLL.ATTRIBUTE14
, PLL.ATTRIBUTE15
, PLL.INSPECTION_REQUIRED_FLAG
, PLL.RECEIPT_REQUIRED_FLAG
, PLL.QTY_RCV_TOLERANCE
, PLL.QTY_RCV_EXCEPTION_CODE
, PLL.ENFORCE_SHIP_TO_LOCATION_CODE
, PLL.ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, PLL.DAYS_EARLY_RECEIPT_ALLOWED
, PLL.DAYS_LATE_RECEIPT_ALLOWED
, PLL.RECEIPT_DAYS_EXCEPTION_CODE
, PLL.INVOICE_CLOSE_TOLERANCE
, PLL.RECEIVE_CLOSE_TOLERANCE
, PLL.SHIP_TO_ORGANIZATION_ID
, PLL.SHIPMENT_NUM
, PLL.SOURCE_SHIPMENT_ID
, PLL.SHIPMENT_TYPE
, PLL.CLOSED_CODE
, PLL.REQUEST_ID
, PLL.PROGRAM_APPLICATION_ID
, PLL.PROGRAM_ID
, PLL.PROGRAM_UPDATE_DATE
, PLL.PROMISED_DATE
, PLL.LAST_ACCEPT_DATE
, PLL.PRICE_OVERRIDE
, PLL.ENCUMBERED_FLAG
, PLL.ENCUMBERED_DATE
, PLL.UNENCUMBERED_QUANTITY
, PLL.FOB_LOOKUP_CODE
, PLL.FREIGHT_TERMS_LOOKUP_CODE
, PLL.TAXABLE_FLAG
, PLL.ESTIMATED_TAX_AMOUNT
, PLL.FROM_HEADER_ID
, PLL.FROM_LINE_ID
, PLL.FROM_LINE_LOCATION_ID
, PLL.START_DATE
, PLL.END_DATE
, PLL.LEAD_TIME
, PLL.LEAD_TIME_UNIT
, PLL.PRICE_DISCOUNT
, PLL.TERMS_ID
, PLL.APPROVED_FLAG
, PLL.APPROVED_DATE
, PLL.CLOSED_FLAG
, PLL.CANCEL_FLAG
, PLL.CANCELLED_BY
, PLL.CANCEL_DATE
, PLL.CANCEL_REASON
, PLL.FIRM_STATUS_LOOKUP_CODE
, PLL.FIRM_DATE
, PLL.ATTRIBUTE_CATEGORY
, PLL.ATTRIBUTE1
, PLL.ATTRIBUTE2
, PLL.ATTRIBUTE3
, PLL.ATTRIBUTE4
, PLL.ATTRIBUTE5
, PLL.LINE_LOCATION_ID
, PLL.LAST_UPDATE_DATE
, PLL.LAST_UPDATED_BY
, PLL.PO_HEADER_ID
, PLL.PO_LINE_ID
, PLL.LAST_UPDATE_LOGIN
, PLL.CREATION_DATE
, PLL.CREATED_BY
, PLL.QUANTITY
, PLL.QUANTITY_RECEIVED
, PLL.QUANTITY_ACCEPTED
, PLL.QUANTITY_REJECTED
, PLL.QUANTITY_BILLED
, PLL.QUANTITY_CANCELLED
, PLL.UNIT_MEAS_LOOKUP_CODE
, PLL.PO_RELEASE_ID
, PLL.SHIP_TO_LOCATION_ID
, PLL.SHIP_VIA_LOOKUP_CODE
, PLL.NEED_BY_DATE
, PLL.GLOBAL_ATTRIBUTE_CATEGORY
, PLL.GLOBAL_ATTRIBUTE1
, PLL.GLOBAL_ATTRIBUTE2
, PLL.GLOBAL_ATTRIBUTE3
, PLL.GLOBAL_ATTRIBUTE4
, PLL.GLOBAL_ATTRIBUTE5
, PLL.GLOBAL_ATTRIBUTE6
, PLL.GLOBAL_ATTRIBUTE7
, PLL.GLOBAL_ATTRIBUTE8
, PLL.GLOBAL_ATTRIBUTE9
, PLL.GLOBAL_ATTRIBUTE10
, PLL.GLOBAL_ATTRIBUTE11
, PLL.GLOBAL_ATTRIBUTE12
, PLL.GLOBAL_ATTRIBUTE13
, PLL.GLOBAL_ATTRIBUTE14
, PLL.GLOBAL_ATTRIBUTE15
, PLL.GLOBAL_ATTRIBUTE16
, PLL.GLOBAL_ATTRIBUTE17
, PLL.GLOBAL_ATTRIBUTE18
, PLL.GLOBAL_ATTRIBUTE19
, PLL.GLOBAL_ATTRIBUTE20
, PLL.QUANTITY_SHIPPED
, PLL.COUNTRY_OF_ORIGIN_CODE
, PLL.TAX_USER_OVERRIDE_FLAG
, PLL.MATCH_OPTION
, PLL.TAX_CODE_ID
, PLL.CALCULATE_TAX_FLAG
, PLL.CHANGE_PROMISED_DATE_REASON
, PLL.NOTE_TO_RECEIVER
, PLL.SECONDARY_UNIT_OF_MEASURE
, PLL.SECONDARY_QUANTITY
, PLL.PREFERRED_GRADE
, PLL.SECONDARY_QUANTITY_RECEIVED
, PLL.SECONDARY_QUANTITY_ACCEPTED
, PLL.SECONDARY_QUANTITY_REJECTED
, PLL.SECONDARY_QUANTITY_CANCELLED
, PLL.VMI_FLAG
, PLL.CONSIGNED_FLAG
, PLL.RETROACTIVE_DATE
, PLL.SUPPLIER_ORDER_LINE_NUMBER
, PLL.AMOUNT
, PLL.AMOUNT_RECEIVED
, PLL.AMOUNT_BILLED
, PLL.AMOUNT_CANCELLED
, PLL.AMOUNT_ACCEPTED
, PLL.AMOUNT_REJECTED
, PLL.DROP_SHIP_FLAG
, PLL.SALES_ORDER_UPDATE_DATE
, PLL.TRANSACTION_FLOW_HEADER_ID
, PLL.FINAL_MATCH_FLAG
, PLL.MANUAL_PRICE_CHANGE_FLAG
, PLL.SHIPMENT_CLOSED_DATE
, PLL.CLOSED_FOR_RECEIVING_DATE
, PLL.CLOSED_FOR_INVOICE_DATE
, PLL.SECONDARY_QUANTITY_SHIPPED
, PLL.VALUE_BASIS
, PLL.MATCHING_BASIS
, PLL.PAYMENT_TYPE
, PLL.DESCRIPTION
, PLL.WORK_APPROVER_ID
, PLL.BID_PAYMENT_ID
, PLL.QUANTITY_FINANCED
, PLL.AMOUNT_FINANCED
, PLL.QUANTITY_RECOUPED
, PLL.AMOUNT_RECOUPED
, PLL.RETAINAGE_WITHHELD_AMOUNT
, PLL.RETAINAGE_RELEASED_AMOUNT
, PLL.AMOUNT_SHIPPED
, PLL.TAX_ATTRIBUTE_UPDATE_CODE
, PLL.OUTSOURCED_ASSEMBLY
, PLL.TAX_NAME
, NULL
, NULL
, PLL.UDA_TEMPLATE_ID
, PLL.CLM_PERIOD_PERF_END_DATE
, PLL.CLM_PERIOD_PERF_START_DATE
, PLL.QUANTITY
, PLL.CLM_DELIVERY_PERIOD
, PLL.CLM_PROMISE_PERIOD
, PLL.CLM_POP_DURATION
, PLL.CLM_DELIVERY_PERIOD_UOM
, PLL.CLM_PROMISE_PERIOD_UOM
, PLL.CLM_POP_DURATION_UOM
, NULL
FROM PO_LINE_LOCATIONS_ALL PLL
, PO_DRAFTS DFT
WHERE PLL.PO_HEADER_ID = DFT.DOCUMENT_ID
AND NOT EXISTS (SELECT 'DRAFT EXISTS FOR THIS SHIPMENT'
FROM PO_LINE_LOCATIONS_DRAFT_ALL PLLD
WHERE PLL.LINE_LOCATION_ID = PLLD.LINE_LOCATION_ID
AND PLLD.DRAFT_ID = DFT.DRAFT_ID
AND NVL(PLLD.DELETE_FLAG
, 'N') = 'N')