[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
Backorders_Only_Flag,
Document_Set_Id,
NULL, -- not in table: document_set_name
Existing_Rsvs_Only_Flag,
Shipment_Priority_Code,
Ship_Method_Code,
NULL, -- not in table: ship_method_name
Customer_Id,
NULL, -- not in table: customer_number
Order_Header_Id,
NULL, -- not in table: order_number
NULL, -- not in table: ship_set_id
Ship_Set_Number,
Inventory_Item_Id,
Order_Type_Id,
NULL, -- not in table: order_type_name
From_Requested_Date,
To_Requested_Date,
From_Scheduled_Ship_Date,
To_Scheduled_Ship_Date,
Ship_To_Location_Id,
NULL, -- not in table: ship_to_location_code
Ship_From_Location_Id,
NULL, -- not in table: ship_from_location_code
Trip_Id,
NULL, -- not in table: trip_name
Delivery_Id,
NULL, -- not in table: delivery_name
Include_Planned_Lines,
Pick_Grouping_Rule_Id,
NULL, -- not in table: pick_grouping_rule_name
Pick_Sequence_Rule_Id,
NULL, -- not in table: pick_sequence_rule_name
Autocreate_Delivery_Flag,
Attribute_Category,
Attribute1,
Attribute2,
Attribute3,
Attribute4,
Attribute5,
Attribute6,
Attribute7,
Attribute8,
Attribute9,
Attribute10,
Attribute11,
Attribute12,
Attribute13,
Attribute14,
Attribute15,
Autodetail_Pr_Flag,
Trip_Stop_Id,
NULL, -- not in table: trip_stop_location_id
Default_Stage_Subinventory,
Default_Stage_Locator_Id,
Pick_From_Subinventory,
Pick_From_locator_Id,
Auto_Pick_Confirm_Flag,
Delivery_Detail_Id,
Project_Id,
Task_Id,
Organization_Id,
NULL, -- not in table: organization_code
Ship_Confirm_Rule_Id,
NULL, -- not in table: ship_confirm_rule_name
Autopack_Flag,
Autopack_Level,
Task_Planning_Flag,
Category_Set_ID,
Category_ID,
Ship_Set_Smc_Flag,
region_ID,
zone_ID,
ac_Delivery_Criteria,
rel_subinventory,
append_flag,
task_priority,
actual_departure_date,
allocation_method, -- X-dock
crossdock_criteria_id, -- X-dock
NULL, -- not in the table:crossdock_criteria_name
dynamic_replenishment_flag, --bug# 6689448 (replenishment project)
-- LSP PROJECT :
client_id,
NULL
-- LSP PROJECT :
FROM wsh_picking_batches
WHERE batch_id = x_batch_id;