The following lines contain the word 'select', 'insert', 'update' or 'delete':
select name into l_object_type
from wms_objects
where object_id = l_object_type_id ;
select distinct name into l_strategy
from wms_strategies_vl
where organization_id in (l_org_id, -1)
and type_code = decode (l_engine_type, 'PICK',2,'PUTAWAY' ,1)
and strategy_id = l_strategy_id;
select name into l_rule
from wms_rules_vl
where organization_id in (l_org_id, -1)
and rule_id = l_rule_id;
select cost_group into l_costgroup
from cst_cost_groups
where organization_id in (l_org_id, -1)
and cost_group_id = l_costgroup_id;
select cost_group into l_costgroup_desc
from cst_cost_groups
where organization_id in (l_org_id, -1)
and cost_group_id = l_costgroup_id;
log_event('WMS_SEARCH_ORDER_GLOBALS_PVT', 'Delete', 'Deleteting all records from WTT');
delete wms_transactions_temp ;
delete mtl_material_transactions_temp
where move_order_line_id = l_line_id;
DELETE_TRACE_ROWS; --(l_line_id);
select organization_id, inventory_item_id
into l_organization_id, l_inventory_item_id
from mtl_txn_request_lines
where line_id = l_line_id;
procedure insert_trace_header
(
p_api_version in NUMBER
,p_init_msg_list in VARCHAR2 DEFAULT fnd_api.g_false
,p_validation_level in NUMBER DEFAULT fnd_api.g_valid_level_full
,x_return_status out NOCOPY VARCHAR2
,x_msg_count out NOCOPY number
,x_msg_data out NOCOPY varchar2
,x_header_id out NOCOPY NUMBER
,p_pick_header_id in NUMBER
,p_move_order_line_id in NUMBER
,p_total_qty in NUMBER
,p_secondary_total_qty in NUMBER
,p_type_code in NUMBER
,p_business_object_id in NUMBER
,p_object_id in NUMBER
,p_strategy_id in NUMBER
) IS
-- API standard variables
l_api_version constant number := 1.0;
l_api_name constant varchar2(30) := ' insert_trace_header';
SELECT wms_rule_trace_header_s.NEXTVAL INTO l_header_id FROM dual;
SELECT Sysdate INTO l_date FROM dual;
/* call the table insert row to do the insert */
insert_headers_row
(
x_header_id => l_header_id
,x_pick_header_id => p_pick_header_id
,x_move_order_line_id => p_move_order_line_id
,x_total_qty => p_total_qty
,x_secondary_total_qty => p_secondary_total_qty
,x_type_code => p_type_code
,x_business_object_id => p_business_object_id
,x_object_id => p_object_id
,x_strategy_id => p_strategy_id
,x_creation_date => l_date
,x_created_by => l_user_id
,x_last_update_date => l_date
,x_last_updated_by => l_user_id
,x_last_update_login => l_login_id
,x_object_name => l_object_name
,x_simulation_mode => G_simulation_mode
,x_sid => l_login_id
);
end insert_trace_header;
procedure insert_trace_lines
(
p_api_version in NUMBER
,p_init_msg_list in VARCHAR2 DEFAULT fnd_api.g_false
,p_validation_level in NUMBER DEFAULT fnd_api.g_valid_level_full
,x_return_status out NOCOPY VARCHAR2
,x_msg_count out NOCOPY number
,x_msg_data out NOCOPY varchar2
,p_header_id in NUMBER
,p_rule_id in NUMBER
,p_pre_suggestions in WMS_SEARCH_ORDER_GLOBALS_PVT.pre_suggestions_record_tbl
) IS
-- API standard variables
g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';
l_api_name constant varchar2(30) := 'insert_trace_lines';
SELECT Sysdate INTO l_date FROM dual;
SELECT wms_rule_trace_lines_s.NEXTVAL INTO l_line_id FROM dual;
/* call the table insert procedure to do the insert */
insert_lines_row
(
x_header_id => l_header_id
,x_line_id => l_line_id
,x_rule_id => l_rule_id
,x_quantity => p_pre_suggestions(l_index).quantity
,x_revision => p_pre_suggestions(l_index).revision
,x_lot_number => p_pre_suggestions(l_index).lot_number
,x_lot_expiration_date => p_pre_suggestions(l_index).lot_expiration_date
,x_serial_number => p_pre_suggestions(l_index).serial_number
,x_subinventory_code => p_pre_suggestions(l_index).subinventory_code
,x_locator_id => p_pre_suggestions(l_index).locator_id
,x_lpn_id => p_pre_suggestions(l_index).lpn_id
,x_cost_group_id => p_pre_suggestions(l_index).cost_group_id
,x_uom_code => p_pre_suggestions(l_index).uom_code
,x_remaining_qty => p_pre_suggestions(l_index).remaining_qty
,x_ATT_qty => p_pre_suggestions(l_index).ATT_qty
,x_suggested_qty => p_pre_suggestions(l_index).suggested_qty
,x_sec_uom_code => p_pre_suggestions(l_index).secondary_uom_code --new
,x_sec_qty => p_pre_suggestions(l_index).secondary_qty --new
,x_sec_ATT_qty => p_pre_suggestions(l_index).secondary_ATT_qty --new
,x_sec_suggested_qty => p_pre_suggestions(l_index).secondary_suggested_qty --new
,x_grade_code => p_pre_suggestions(l_index).grade_code --new
,x_same_subinv_loc_flag => p_pre_suggestions(l_index).same_subinv_loc_flag
,x_ATT_qty_flag => p_pre_suggestions(l_index).ATT_qty_flag
,x_consist_string_flag => p_pre_suggestions(l_index).consist_string_flag
,x_order_string_flag => p_pre_suggestions(l_index).order_string_flag
,x_Material_status_flag => p_pre_suggestions(l_index).Material_status_flag
,x_Pick_UOM_flag => p_pre_suggestions(l_index).Pick_UOM_flag
,x_partial_pick_flag => p_pre_suggestions(l_index).partial_pick_flag
,x_Serial_number_used_flag => p_pre_suggestions(l_index).Serial_number_used_flag
,x_CG_comingle_flag => p_pre_suggestions(l_index).CG_comingle_flag
,x_entire_lpn_flag => p_pre_suggestions(l_index).entire_lpn_flag
,x_comments => p_pre_suggestions(l_index).comments
,x_creation_date => l_date
,x_created_by => l_user_id
,x_last_update_date => l_date
,x_last_updated_by => l_user_id
,x_last_update_login => l_login_id
);
end insert_trace_lines;
Procedure insert_headers_row
(
x_header_id IN NUMBER,
x_pick_header_id IN NUMBER,
x_move_order_line_id IN NUMBER,
x_total_qty IN NUMBER,
x_secondary_total_qty IN NUMBER,
x_type_code IN NUMBER,
x_business_object_id IN NUMBER,
x_object_id IN NUMBER,
x_strategy_id IN NUMBER,
x_last_updated_by IN NUMBER,
x_last_update_date IN DATE ,
x_created_by IN NUMBER ,
x_creation_date IN DATE ,
x_last_update_login IN NUMBER ,
x_object_name IN VARCHAR2,
x_simulation_mode IN VARCHAR2,
x_sid IN NUMBER
)
is
---- This API Call is a Autonomous Procedure ---------------
PRAGMA AUTONOMOUS_TRANSACTION;
INSERT into WMS_RULE_TRACE_HEADERS (
header_id
,pick_header_id
,move_order_line_id
,total_qty
,secondary_total_qty
,type_code
,business_object_id
,object_id
,strategy_id
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login
,object_name
,simulation_mode
,sid
) VALUES
(
x_header_id
,x_pick_header_id
,x_move_order_line_id
,x_total_qty
,x_secondary_total_qty
,x_type_code
,x_business_object_id
,x_object_id
,x_strategy_id
,x_creation_date
,x_created_by
,x_last_update_date
,x_last_updated_by
,x_last_update_login
,x_object_name
,x_simulation_mode
,x_sid
);
end insert_headers_row;
Procedure insert_lines_row
(
x_header_id IN NUMBER
,x_line_id IN NUMBER
,x_rule_id IN NUMBER
,x_quantity IN NUMBER
,x_revision IN VARCHAR2
,x_lot_number IN VARCHAR2
,x_lot_expiration_date IN DATE
,x_serial_number IN VARCHAR2
,x_subinventory_code IN VARCHAR2
,x_locator_id IN NUMBER
,x_lpn_id IN NUMBER
,x_cost_group_id IN NUMBER
,x_uom_code IN VARCHAR2
,x_remaining_qty IN NUMBER
,x_ATT_qty IN NUMBER
,x_suggested_qty IN NUMBER
,x_sec_uom_code IN VARCHAR2 -- new
,x_sec_qty IN NUMBER -- new
,x_sec_ATT_qty IN NUMBER -- new
,x_sec_suggested_qty IN NUMBER -- new
,x_grade_code IN VARCHAR2 -- new
,x_same_subinv_loc_flag IN VARCHAR2
,x_ATT_qty_flag IN VARCHAR2
,x_consist_string_flag IN VARCHAR2
,x_order_string_flag IN VARCHAR2
,x_Material_status_flag IN VARCHAR2
,x_Pick_UOM_flag IN VARCHAR2
,x_partial_pick_flag IN VARCHAR2
,x_Serial_number_used_flag IN VARCHAR2
,x_CG_comingle_flag IN VARCHAR2
,x_entire_lpn_flag IN VARCHAR2
,x_comments IN VARCHAR2
,x_creation_date IN DATE
,x_created_by IN NUMBER
,x_last_update_date IN DATE
,x_last_updated_by IN NUMBER
,x_last_update_login IN NUMBER
)
is
---- This API Call is a Autonomous Procedure ---------------
PRAGMA AUTONOMOUS_TRANSACTION;
insert into WMS_RULE_TRACE_LINES
(
header_id
,line_id
,rule_id
,quantity
,revision
,lot_number
,lot_expiration_date
,serial_number
,subinventory_code
,locator_id
,lpn_id
,cost_group_id
,uom_code
,remaining_qty
,ATT_qty
,suggested_qty -- new
,secondary_uom_code -- new
,secondary_quantity -- new
,secondary_ATT_qty -- new
,secondary_suggested_qty -- new
,grade_code -- new
,same_subinv_loc_flag
,ATT_qty_flag
,consist_string_flag
,order_string_flag
,Material_status_flag
,Pick_UOM_flag
,partial_pick_flag
,Serial_number_used_flag
,CG_comingle_flag
,entire_lpn_flag
,comments
,last_updated_by
,last_update_date
,created_by
,creation_date
,last_update_login
) VALUES
(
x_header_id
,x_line_id
,x_rule_id
,x_quantity
,x_revision
,x_lot_number
,x_lot_expiration_date
,x_serial_number
,x_subinventory_code
,x_locator_id
,x_lpn_id
,x_cost_group_id
,x_uom_code
,x_remaining_qty
,x_ATT_qty
,x_suggested_qty
,x_sec_uom_code -- new
,x_sec_qty -- new
,x_sec_ATT_qty -- new
,x_sec_suggested_qty -- new
,x_grade_code
,x_same_subinv_loc_flag
,x_ATT_qty_flag
,x_consist_string_flag
,x_order_string_flag
,x_Material_status_flag
,x_Pick_UOM_flag
,x_partial_pick_flag
,x_Serial_number_used_flag
,x_CG_comingle_flag
,x_entire_lpn_flag
,x_comments
,x_last_updated_by
,x_last_update_date
,x_created_by
,x_creation_date
,x_last_update_login
);
end insert_lines_row;
FUNCTION IS_Object_selected ( p_move_order_line_id number,
p_engine_type Varchar2,
p_object_type varchar2,
p_object_id number )
RETURN VARCHAR2 is
l_object_type VARCHAR2(80) := NULL;
l_api_name constant VARCHAR2(30) := 'IS_object_Selected';
select distinct pick_rule_id into l_rule_id
from wms_suggestions_temp_v
where pick_rule_id = l_object_id ;
END IS_Object_selected;
FUNCTION IS_BO_Object_selected ( p_move_order_line_id number,
p_engine_type Varchar2, /*'PICK', 'PUTAWAY' .. */
p_object_type varchar2, /* 'SO', 'BO' ... */
p_object varchar2 ) /* object name*/
RETURN VARCHAR2 is
l_object_type VARCHAR2(80) := NULL;
l_api_name constant VARCHAR2(30) := 'IS_BO_object_Selected';
select organization_id into l_org_id
from mtl_txn_request_lines
where line_id = l_line_id;
END IS_BO_Object_selected;
PROCEDURE DELETE_TRACE_ROWS is
PRAGMA AUTONOMOUS_TRANSACTION;
delete wms_rule_trace_lines
where header_id in (select header_id
from wms_rule_trace_headers
where simulation_mode = 'Y'
and sid = l_login_id);
delete wms_rule_trace_headers
where simulation_mode = 'Y'
and sid = l_login_id;
END DELETE_TRACE_ROWS;
procedure insert_txn_trace_rows(
p_api_version in NUMBER
,p_init_msg_list in VARCHAR2 DEFAULT fnd_api.g_false
,p_validation_level in NUMBER DEFAULT fnd_api.g_valid_level_full
,x_return_status out NOCOPY VARCHAR2
,x_msg_count out NOCOPY number
,x_msg_data out NOCOPY varchar2
,p_txn_header_id in number
,p_insert_lot_flag in number
,p_insert_serial_flag in number) is
---- This API Call is a Autonomous Procedure ---------------
--- PRAGMA AUTONOMOUS_TRANSACTION;
l_api_name constant varchar2(30) := 'insert_txn_trace_rows';
l_insert_lot_flag number;
l_insert_serial_flag number;
l_insert_lot_flag := nvl(p_insert_lot_flag,0);
l_insert_serial_flag := nvl(p_insert_serial_flag,0);
insert into WMS_MATERIAL_TXN_TRACE
(
TRANSACTION_HEADER_ID ,
TRANSACTION_TEMP_ID ,
SOURCE_CODE ,
SOURCE_LINE_ID ,
TRANSACTION_MODE ,
LOCK_FLAG ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_LOGIN ,
REQUEST_ID ,
PROGRAM_APPLICATION_ID ,
PROGRAM_ID ,
PROGRAM_UPDATE_DATE ,
INVENTORY_ITEM_ID ,
REVISION ,
ORGANIZATION_ID ,
SUBINVENTORY_CODE ,
LOCATOR_ID ,
TRANSACTION_QUANTITY ,
PRIMARY_QUANTITY ,
TRANSACTION_UOM ,
TRANSACTION_COST ,
TRANSACTION_TYPE_ID ,
TRANSACTION_ACTION_ID ,
TRANSACTION_SOURCE_TYPE_ID ,
TRANSACTION_SOURCE_ID ,
TRANSACTION_SOURCE_NAME ,
TRANSACTION_DATE ,
ACCT_PERIOD_ID ,
DISTRIBUTION_ACCOUNT_ID ,
TRANSACTION_REFERENCE ,
REQUISITION_LINE_ID ,
REQUISITION_DISTRIBUTION_ID ,
REASON_ID ,
LOT_NUMBER ,
LOT_EXPIRATION_DATE ,
SERIAL_NUMBER ,
RECEIVING_DOCUMENT ,
DEMAND_ID ,
RCV_TRANSACTION_ID ,
MOVE_TRANSACTION_ID ,
COMPLETION_TRANSACTION_ID ,
WIP_ENTITY_TYPE ,
SCHEDULE_ID ,
REPETITIVE_LINE_ID ,
EMPLOYEE_CODE ,
PRIMARY_SWITCH ,
SCHEDULE_UPDATE_CODE ,
SETUP_TEARDOWN_CODE ,
ITEM_ORDERING ,
NEGATIVE_REQ_FLAG ,
OPERATION_SEQ_NUM ,
PICKING_LINE_ID ,
TRX_SOURCE_LINE_ID ,
TRX_SOURCE_DELIVERY_ID ,
PHYSICAL_ADJUSTMENT_ID ,
CYCLE_COUNT_ID ,
RMA_LINE_ID ,
CUSTOMER_SHIP_ID ,
CURRENCY_CODE ,
CURRENCY_CONVERSION_RATE ,
CURRENCY_CONVERSION_TYPE ,
CURRENCY_CONVERSION_DATE ,
USSGL_TRANSACTION_CODE ,
VENDOR_LOT_NUMBER ,
ENCUMBRANCE_ACCOUNT ,
ENCUMBRANCE_AMOUNT ,
SHIP_TO_LOCATION ,
SHIPMENT_NUMBER ,
TRANSFER_COST ,
TRANSPORTATION_COST ,
TRANSPORTATION_ACCOUNT ,
FREIGHT_CODE ,
CONTAINERS ,
WAYBILL_AIRBILL ,
EXPECTED_ARRIVAL_DATE ,
TRANSFER_SUBINVENTORY ,
TRANSFER_ORGANIZATION ,
TRANSFER_TO_LOCATION ,
NEW_AVERAGE_COST ,
VALUE_CHANGE ,
PERCENTAGE_CHANGE ,
MATERIAL_ALLOCATION_TEMP_ID ,
DEMAND_SOURCE_HEADER_ID ,
DEMAND_SOURCE_LINE ,
DEMAND_SOURCE_DELIVERY ,
ITEM_SEGMENTS ,
ITEM_DESCRIPTION ,
ITEM_TRX_ENABLED_FLAG ,
ITEM_LOCATION_CONTROL_CODE ,
ITEM_RESTRICT_SUBINV_CODE ,
ITEM_RESTRICT_LOCATORS_CODE ,
ITEM_REVISION_QTY_CONTROL_CODE ,
ITEM_PRIMARY_UOM_CODE ,
ITEM_UOM_CLASS ,
ITEM_SHELF_LIFE_CODE ,
ITEM_SHELF_LIFE_DAYS ,
ITEM_LOT_CONTROL_CODE ,
ITEM_SERIAL_CONTROL_CODE ,
ITEM_INVENTORY_ASSET_FLAG ,
ALLOWED_UNITS_LOOKUP_CODE ,
DEPARTMENT_ID ,
DEPARTMENT_CODE ,
WIP_SUPPLY_TYPE ,
SUPPLY_SUBINVENTORY ,
SUPPLY_LOCATOR_ID ,
VALID_SUBINVENTORY_FLAG ,
VALID_LOCATOR_FLAG ,
LOCATOR_SEGMENTS ,
CURRENT_LOCATOR_CONTROL_CODE ,
NUMBER_OF_LOTS_ENTERED ,
WIP_COMMIT_FLAG ,
NEXT_LOT_NUMBER ,
LOT_ALPHA_PREFIX ,
NEXT_SERIAL_NUMBER ,
SERIAL_ALPHA_PREFIX ,
SHIPPABLE_FLAG ,
POSTING_FLAG ,
REQUIRED_FLAG ,
PROCESS_FLAG ,
ERROR_CODE ,
ERROR_EXPLANATION ,
ATTRIBUTE_CATEGORY ,
ATTRIBUTE1 ,
ATTRIBUTE2 ,
ATTRIBUTE3 ,
ATTRIBUTE4 ,
ATTRIBUTE5 ,
ATTRIBUTE6 ,
ATTRIBUTE7 ,
ATTRIBUTE8 ,
ATTRIBUTE9 ,
ATTRIBUTE10 ,
ATTRIBUTE11 ,
ATTRIBUTE12 ,
ATTRIBUTE13 ,
ATTRIBUTE14 ,
ATTRIBUTE15 ,
MOVEMENT_ID ,
RESERVATION_QUANTITY ,
SHIPPED_QUANTITY ,
TRANSACTION_LINE_NUMBER ,
TASK_ID ,
TO_TASK_ID ,
SOURCE_TASK_ID ,
PROJECT_ID ,
SOURCE_PROJECT_ID ,
PA_EXPENDITURE_ORG_ID ,
TO_PROJECT_ID ,
EXPENDITURE_TYPE ,
FINAL_COMPLETION_FLAG ,
TRANSFER_PERCENTAGE ,
TRANSACTION_SEQUENCE_ID ,
MATERIAL_ACCOUNT ,
MATERIAL_OVERHEAD_ACCOUNT ,
RESOURCE_ACCOUNT ,
OUTSIDE_PROCESSING_ACCOUNT ,
OVERHEAD_ACCOUNT ,
FLOW_SCHEDULE ,
COST_GROUP_ID ,
DEMAND_CLASS ,
QA_COLLECTION_ID ,
KANBAN_CARD_ID ,
OVERCOMPLETION_TRANSACTION_QTY ,
OVERCOMPLETION_PRIMARY_QTY ,
OVERCOMPLETION_TRANSACTION_ID ,
END_ITEM_UNIT_NUMBER ,
SCHEDULED_PAYBACK_DATE ,
LINE_TYPE_CODE ,
PARENT_TRANSACTION_TEMP_ID ,
PUT_AWAY_STRATEGY_ID ,
PUT_AWAY_RULE_ID ,
PICK_STRATEGY_ID ,
PICK_RULE_ID ,
MOVE_ORDER_LINE_ID ,
TASK_GROUP_ID ,
PICK_SLIP_NUMBER ,
RESERVATION_ID ,
COMMON_BOM_SEQ_ID ,
COMMON_ROUTING_SEQ_ID ,
ORG_COST_GROUP_ID ,
COST_TYPE_ID ,
TRANSACTION_STATUS ,
STANDARD_OPERATION_ID ,
TASK_PRIORITY ,
WMS_TASK_TYPE ,
PARENT_LINE_ID ,
SOURCE_LOT_NUMBER ,
TRANSFER_COST_GROUP_ID ,
LPN_ID ,
TRANSFER_LPN_ID ,
WMS_TASK_STATUS ,
CONTENT_LPN_ID ,
CONTAINER_ITEM_ID ,
CARTONIZATION_ID ,
PICK_SLIP_DATE ,
REBUILD_ITEM_ID ,
REBUILD_SERIAL_NUMBER ,
REBUILD_ACTIVITY_ID ,
REBUILD_JOB_NAME ,
ORGANIZATION_TYPE ,
TRANSFER_ORGANIZATION_TYPE ,
OWNING_ORGANIZATION_ID ,
OWNING_TP_TYPE ,
XFR_OWNING_ORGANIZATION_ID ,
TRANSFER_OWNING_TP_TYPE ,
PLANNING_ORGANIZATION_ID ,
PLANNING_TP_TYPE ,
XFR_PLANNING_ORGANIZATION_ID ,
TRANSFER_PLANNING_TP_TYPE ,
SECONDARY_UOM_CODE , -- new
SECONDARY_TRANSACTION_QUANTITY , -- new
ALLOCATED_LPN_ID ,
SCHEDULE_NUMBER ,
SCHEDULED_FLAG ,
CLASS_CODE ,
SCHEDULE_GROUP ,
BUILD_SEQUENCE ,
BOM_REVISION ,
ROUTING_REVISION ,
BOM_REVISION_DATE ,
ROUTING_REVISION_DATE ,
ALTERNATE_BOM_DESIGNATOR ,
ALTERNATE_ROUTING_DESIGNATOR
)
select
TRANSACTION_HEADER_ID ,
TRANSACTION_TEMP_ID ,
SOURCE_CODE ,
SOURCE_LINE_ID ,
TRANSACTION_MODE ,
LOCK_FLAG ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_LOGIN ,
REQUEST_ID ,
PROGRAM_APPLICATION_ID ,
PROGRAM_ID ,
PROGRAM_UPDATE_DATE ,
INVENTORY_ITEM_ID ,
REVISION ,
ORGANIZATION_ID ,
SUBINVENTORY_CODE ,
LOCATOR_ID ,
TRANSACTION_QUANTITY ,
PRIMARY_QUANTITY ,
TRANSACTION_UOM ,
TRANSACTION_COST ,
TRANSACTION_TYPE_ID ,
TRANSACTION_ACTION_ID ,
TRANSACTION_SOURCE_TYPE_ID ,
TRANSACTION_SOURCE_ID ,
TRANSACTION_SOURCE_NAME ,
TRANSACTION_DATE ,
ACCT_PERIOD_ID ,
DISTRIBUTION_ACCOUNT_ID ,
TRANSACTION_REFERENCE ,
REQUISITION_LINE_ID ,
REQUISITION_DISTRIBUTION_ID ,
REASON_ID ,
LOT_NUMBER ,
LOT_EXPIRATION_DATE ,
SERIAL_NUMBER ,
RECEIVING_DOCUMENT ,
DEMAND_ID ,
RCV_TRANSACTION_ID ,
MOVE_TRANSACTION_ID ,
COMPLETION_TRANSACTION_ID ,
WIP_ENTITY_TYPE ,
SCHEDULE_ID ,
REPETITIVE_LINE_ID ,
EMPLOYEE_CODE ,
PRIMARY_SWITCH ,
SCHEDULE_UPDATE_CODE ,
SETUP_TEARDOWN_CODE ,
ITEM_ORDERING ,
NEGATIVE_REQ_FLAG ,
OPERATION_SEQ_NUM ,
PICKING_LINE_ID ,
TRX_SOURCE_LINE_ID ,
TRX_SOURCE_DELIVERY_ID ,
PHYSICAL_ADJUSTMENT_ID ,
CYCLE_COUNT_ID ,
RMA_LINE_ID ,
CUSTOMER_SHIP_ID ,
CURRENCY_CODE ,
CURRENCY_CONVERSION_RATE ,
CURRENCY_CONVERSION_TYPE ,
CURRENCY_CONVERSION_DATE ,
USSGL_TRANSACTION_CODE ,
VENDOR_LOT_NUMBER ,
ENCUMBRANCE_ACCOUNT ,
ENCUMBRANCE_AMOUNT ,
SHIP_TO_LOCATION ,
SHIPMENT_NUMBER ,
TRANSFER_COST ,
TRANSPORTATION_COST ,
TRANSPORTATION_ACCOUNT ,
FREIGHT_CODE ,
CONTAINERS ,
WAYBILL_AIRBILL ,
EXPECTED_ARRIVAL_DATE ,
TRANSFER_SUBINVENTORY ,
TRANSFER_ORGANIZATION ,
TRANSFER_TO_LOCATION ,
NEW_AVERAGE_COST ,
VALUE_CHANGE ,
PERCENTAGE_CHANGE ,
MATERIAL_ALLOCATION_TEMP_ID ,
DEMAND_SOURCE_HEADER_ID ,
DEMAND_SOURCE_LINE ,
DEMAND_SOURCE_DELIVERY ,
ITEM_SEGMENTS ,
ITEM_DESCRIPTION ,
ITEM_TRX_ENABLED_FLAG ,
ITEM_LOCATION_CONTROL_CODE ,
ITEM_RESTRICT_SUBINV_CODE ,
ITEM_RESTRICT_LOCATORS_CODE ,
ITEM_REVISION_QTY_CONTROL_CODE ,
ITEM_PRIMARY_UOM_CODE ,
ITEM_UOM_CLASS ,
ITEM_SHELF_LIFE_CODE ,
ITEM_SHELF_LIFE_DAYS ,
ITEM_LOT_CONTROL_CODE ,
ITEM_SERIAL_CONTROL_CODE ,
ITEM_INVENTORY_ASSET_FLAG ,
ALLOWED_UNITS_LOOKUP_CODE ,
DEPARTMENT_ID ,
DEPARTMENT_CODE ,
WIP_SUPPLY_TYPE ,
SUPPLY_SUBINVENTORY ,
SUPPLY_LOCATOR_ID ,
VALID_SUBINVENTORY_FLAG ,
VALID_LOCATOR_FLAG ,
LOCATOR_SEGMENTS ,
CURRENT_LOCATOR_CONTROL_CODE ,
NUMBER_OF_LOTS_ENTERED ,
WIP_COMMIT_FLAG ,
NEXT_LOT_NUMBER ,
LOT_ALPHA_PREFIX ,
NEXT_SERIAL_NUMBER ,
SERIAL_ALPHA_PREFIX ,
SHIPPABLE_FLAG ,
POSTING_FLAG ,
REQUIRED_FLAG ,
PROCESS_FLAG ,
ERROR_CODE ,
ERROR_EXPLANATION ,
ATTRIBUTE_CATEGORY ,
ATTRIBUTE1 ,
ATTRIBUTE2 ,
ATTRIBUTE3 ,
ATTRIBUTE4 ,
ATTRIBUTE5 ,
ATTRIBUTE6 ,
ATTRIBUTE7 ,
ATTRIBUTE8 ,
ATTRIBUTE9 ,
ATTRIBUTE10 ,
ATTRIBUTE11 ,
ATTRIBUTE12 ,
ATTRIBUTE13 ,
ATTRIBUTE14 ,
ATTRIBUTE15 ,
MOVEMENT_ID ,
RESERVATION_QUANTITY ,
SHIPPED_QUANTITY ,
TRANSACTION_LINE_NUMBER ,
TASK_ID ,
TO_TASK_ID ,
SOURCE_TASK_ID ,
PROJECT_ID ,
SOURCE_PROJECT_ID ,
PA_EXPENDITURE_ORG_ID ,
TO_PROJECT_ID ,
EXPENDITURE_TYPE ,
FINAL_COMPLETION_FLAG ,
TRANSFER_PERCENTAGE ,
TRANSACTION_SEQUENCE_ID ,
MATERIAL_ACCOUNT ,
MATERIAL_OVERHEAD_ACCOUNT ,
RESOURCE_ACCOUNT ,
OUTSIDE_PROCESSING_ACCOUNT ,
OVERHEAD_ACCOUNT ,
FLOW_SCHEDULE ,
COST_GROUP_ID ,
DEMAND_CLASS ,
QA_COLLECTION_ID ,
KANBAN_CARD_ID ,
OVERCOMPLETION_TRANSACTION_QTY ,
OVERCOMPLETION_PRIMARY_QTY ,
OVERCOMPLETION_TRANSACTION_ID ,
END_ITEM_UNIT_NUMBER ,
SCHEDULED_PAYBACK_DATE ,
LINE_TYPE_CODE ,
PARENT_TRANSACTION_TEMP_ID ,
PUT_AWAY_STRATEGY_ID ,
PUT_AWAY_RULE_ID ,
PICK_STRATEGY_ID ,
PICK_RULE_ID ,
MOVE_ORDER_LINE_ID ,
TASK_GROUP_ID ,
PICK_SLIP_NUMBER ,
RESERVATION_ID ,
COMMON_BOM_SEQ_ID ,
COMMON_ROUTING_SEQ_ID ,
ORG_COST_GROUP_ID ,
COST_TYPE_ID ,
TRANSACTION_STATUS ,
STANDARD_OPERATION_ID ,
TASK_PRIORITY ,
WMS_TASK_TYPE ,
PARENT_LINE_ID ,
' ' ,
TRANSFER_COST_GROUP_ID ,
LPN_ID ,
TRANSFER_LPN_ID ,
WMS_TASK_STATUS ,
CONTENT_LPN_ID ,
CONTAINER_ITEM_ID ,
CARTONIZATION_ID ,
PICK_SLIP_DATE ,
REBUILD_ITEM_ID ,
REBUILD_SERIAL_NUMBER ,
REBUILD_ACTIVITY_ID ,
REBUILD_JOB_NAME ,
ORGANIZATION_TYPE ,
TRANSFER_ORGANIZATION_TYPE ,
OWNING_ORGANIZATION_ID ,
OWNING_TP_TYPE ,
XFR_OWNING_ORGANIZATION_ID ,
TRANSFER_OWNING_TP_TYPE ,
PLANNING_ORGANIZATION_ID ,
PLANNING_TP_TYPE ,
XFR_PLANNING_ORGANIZATION_ID ,
TRANSFER_PLANNING_TP_TYPE ,
SECONDARY_UOM_CODE , -- new
SECONDARY_TRANSACTION_QUANTITY , -- new
ALLOCATED_LPN_ID ,
SCHEDULE_NUMBER ,
SCHEDULED_FLAG ,
CLASS_CODE ,
SCHEDULE_GROUP ,
BUILD_SEQUENCE ,
BOM_REVISION ,
ROUTING_REVISION ,
BOM_REVISION_DATE ,
ROUTING_REVISION_DATE ,
ALTERNATE_BOM_DESIGNATOR ,
ALTERNATE_ROUTING_DESIGNATOR
from mtl_material_transactions_temp
where transaction_header_id = l_txn_header_id;
If (l_insert_lot_flag = 1) then
insert into wms_transaction_lots_trace
(
TRANSACTION_TEMP_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN ,
REQUEST_ID ,
PROGRAM_APPLICATION_ID ,
PROGRAM_ID ,
PROGRAM_UPDATE_DATE ,
TRANSACTION_QUANTITY,
PRIMARY_QUANTITY,
SECONDARY_QUANTITY, -- new
GRADE_CODE, -- new
LOT_NUMBER ,
LOT_EXPIRATION_DATE ,
ERROR_CODE ,
SERIAL_TRANSACTION_TEMP_ID ,
GROUP_HEADER_ID ,
PUT_AWAY_RULE_ID ,
PICK_RULE_ID ,
DESCRIPTION ,
VENDOR_NAME ,
SUPPLIER_LOT_NUMBER,
ORIGINATION_DATE ,
DATE_CODE ,
CHANGE_DATE ,
MATURITY_DATE ,
STATUS_ID ,
RETEST_DATE ,
AGE ,
ITEM_SIZE ,
COLOR ,
VOLUME ,
VOLUME_UOM ,
PLACE_OF_ORIGIN ,
BEST_BY_DATE ,
LENGTH ,
LENGTH_UOM ,
RECYCLED_CONTENT ,
THICKNESS ,
THICKNESS_UOM ,
WIDTH ,
WIDTH_UOM ,
CURL_WRINKLE_FOLD ,
LOT_ATTRIBUTE_CATEGORY,
C_ATTRIBUTE1 ,
C_ATTRIBUTE2 ,
C_ATTRIBUTE3 ,
C_ATTRIBUTE4 ,
C_ATTRIBUTE5 ,
C_ATTRIBUTE6 ,
C_ATTRIBUTE7 ,
C_ATTRIBUTE8 ,
C_ATTRIBUTE9 ,
C_ATTRIBUTE10 ,
C_ATTRIBUTE11 ,
C_ATTRIBUTE12 ,
C_ATTRIBUTE13 ,
C_ATTRIBUTE14 ,
C_ATTRIBUTE15 ,
C_ATTRIBUTE16 ,
C_ATTRIBUTE17 ,
C_ATTRIBUTE18 ,
C_ATTRIBUTE19 ,
C_ATTRIBUTE20 ,
D_ATTRIBUTE1 ,
D_ATTRIBUTE2 ,
D_ATTRIBUTE3 ,
D_ATTRIBUTE4 ,
D_ATTRIBUTE5 ,
D_ATTRIBUTE6 ,
D_ATTRIBUTE7 ,
D_ATTRIBUTE8 ,
D_ATTRIBUTE9 ,
D_ATTRIBUTE10 ,
N_ATTRIBUTE1 ,
N_ATTRIBUTE2 ,
N_ATTRIBUTE3 ,
N_ATTRIBUTE4 ,
N_ATTRIBUTE5 ,
N_ATTRIBUTE6 ,
N_ATTRIBUTE7 ,
N_ATTRIBUTE8 ,
N_ATTRIBUTE9 ,
N_ATTRIBUTE10 ,
VENDOR_ID ,
TERRITORY_CODE ,
SUBLOT_NUM ,
SECONDARY_UNIT_OF_MEASURE ,
QC_GRADE )
select
TRANSACTION_TEMP_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN ,
REQUEST_ID ,
PROGRAM_APPLICATION_ID ,
PROGRAM_ID ,
PROGRAM_UPDATE_DATE ,
TRANSACTION_QUANTITY,
PRIMARY_QUANTITY,
SECONDARY_QUANTITY, -- new
GRADE_CODE, -- new
LOT_NUMBER ,
LOT_EXPIRATION_DATE ,
ERROR_CODE ,
SERIAL_TRANSACTION_TEMP_ID ,
GROUP_HEADER_ID ,
PUT_AWAY_RULE_ID ,
PICK_RULE_ID ,
DESCRIPTION ,
VENDOR_NAME ,
SUPPLIER_LOT_NUMBER,
ORIGINATION_DATE ,
DATE_CODE ,
CHANGE_DATE ,
MATURITY_DATE ,
STATUS_ID ,
RETEST_DATE ,
AGE ,
ITEM_SIZE ,
COLOR ,
VOLUME ,
VOLUME_UOM ,
PLACE_OF_ORIGIN ,
BEST_BY_DATE ,
LENGTH ,
LENGTH_UOM ,
RECYCLED_CONTENT ,
THICKNESS ,
THICKNESS_UOM ,
WIDTH ,
WIDTH_UOM ,
CURL_WRINKLE_FOLD ,
LOT_ATTRIBUTE_CATEGORY,
C_ATTRIBUTE1 ,
C_ATTRIBUTE2 ,
C_ATTRIBUTE3 ,
C_ATTRIBUTE4 ,
C_ATTRIBUTE5 ,
C_ATTRIBUTE6 ,
C_ATTRIBUTE7 ,
C_ATTRIBUTE8 ,
C_ATTRIBUTE9 ,
C_ATTRIBUTE10 ,
C_ATTRIBUTE11 ,
C_ATTRIBUTE12 ,
C_ATTRIBUTE13 ,
C_ATTRIBUTE14 ,
C_ATTRIBUTE15 ,
C_ATTRIBUTE16 ,
C_ATTRIBUTE17 ,
C_ATTRIBUTE18 ,
C_ATTRIBUTE19 ,
C_ATTRIBUTE20 ,
D_ATTRIBUTE1 ,
D_ATTRIBUTE2 ,
D_ATTRIBUTE3 ,
D_ATTRIBUTE4 ,
D_ATTRIBUTE5 ,
D_ATTRIBUTE6 ,
D_ATTRIBUTE7 ,
D_ATTRIBUTE8 ,
D_ATTRIBUTE9 ,
D_ATTRIBUTE10 ,
N_ATTRIBUTE1 ,
N_ATTRIBUTE2 ,
N_ATTRIBUTE3 ,
N_ATTRIBUTE4 ,
N_ATTRIBUTE5 ,
N_ATTRIBUTE6 ,
N_ATTRIBUTE7 ,
N_ATTRIBUTE8 ,
N_ATTRIBUTE9 ,
N_ATTRIBUTE10 ,
VENDOR_ID ,
TERRITORY_CODE ,
SUBLOT_NUM ,
SECONDARY_UNIT_OF_MEASURE ,
QC_GRADE
from mtl_transaction_lots_temp
where transaction_temp_id in ( select transaction_temp_id
from wms_material_txn_trace
where transaction_header_id = l_txn_header_id);
If (l_insert_serial_flag = 1 and l_insert_lot_flag = 0) then
insert into wms_serial_numbers_trace
(
TRANSACTION_TEMP_ID ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_LOGIN ,
REQUEST_ID ,
PROGRAM_APPLICATION_ID ,
PROGRAM_ID ,
PROGRAM_UPDATE_DATE ,
VENDOR_SERIAL_NUMBER ,
VENDOR_LOT_NUMBER ,
FM_SERIAL_NUMBER ,
TO_SERIAL_NUMBER ,
SERIAL_PREFIX ,
ERROR_CODE ,
GROUP_HEADER_ID ,
PARENT_SERIAL_NUMBER ,
END_ITEM_UNIT_NUMBER ,
SERIAL_ATTRIBUTE_CATEGORY ,
ORIGINATION_DATE ,
C_ATTRIBUTE1 ,
C_ATTRIBUTE2 ,
C_ATTRIBUTE3 ,
C_ATTRIBUTE4 ,
C_ATTRIBUTE5 ,
C_ATTRIBUTE6 ,
C_ATTRIBUTE7 ,
C_ATTRIBUTE8 ,
C_ATTRIBUTE9 ,
C_ATTRIBUTE10 ,
C_ATTRIBUTE11 ,
C_ATTRIBUTE12 ,
C_ATTRIBUTE13 ,
C_ATTRIBUTE14 ,
C_ATTRIBUTE15 ,
C_ATTRIBUTE16 ,
C_ATTRIBUTE17 ,
C_ATTRIBUTE18 ,
C_ATTRIBUTE19 ,
C_ATTRIBUTE20 ,
D_ATTRIBUTE1 ,
D_ATTRIBUTE2 ,
D_ATTRIBUTE3 ,
D_ATTRIBUTE4 ,
D_ATTRIBUTE5 ,
D_ATTRIBUTE6 ,
D_ATTRIBUTE7 ,
D_ATTRIBUTE8 ,
D_ATTRIBUTE9 ,
D_ATTRIBUTE10 ,
N_ATTRIBUTE1 ,
N_ATTRIBUTE2 ,
N_ATTRIBUTE3 ,
N_ATTRIBUTE4 ,
N_ATTRIBUTE5 ,
N_ATTRIBUTE6 ,
N_ATTRIBUTE7 ,
N_ATTRIBUTE8 ,
N_ATTRIBUTE9 ,
N_ATTRIBUTE10 ,
STATUS_ID ,
TERRITORY_CODE ,
TIME_SINCE_NEW ,
CYCLES_SINCE_NEW ,
TIME_SINCE_OVERHAUL,
CYCLES_SINCE_OVERHAUL,
TIME_SINCE_REPAIR ,
CYCLES_SINCE_REPAIR ,
TIME_SINCE_VISIT ,
CYCLES_SINCE_VISIT ,
TIME_SINCE_MARK ,
CYCLES_SINCE_MARK ,
NUMBER_OF_REPAIRS
)
select
TRANSACTION_TEMP_ID ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_LOGIN ,
REQUEST_ID ,
PROGRAM_APPLICATION_ID ,
PROGRAM_ID ,
PROGRAM_UPDATE_DATE ,
VENDOR_SERIAL_NUMBER ,
VENDOR_LOT_NUMBER ,
FM_SERIAL_NUMBER ,
TO_SERIAL_NUMBER ,
SERIAL_PREFIX ,
ERROR_CODE ,
GROUP_HEADER_ID ,
PARENT_SERIAL_NUMBER ,
END_ITEM_UNIT_NUMBER ,
SERIAL_ATTRIBUTE_CATEGORY ,
ORIGINATION_DATE ,
C_ATTRIBUTE1 ,
C_ATTRIBUTE2 ,
C_ATTRIBUTE3 ,
C_ATTRIBUTE4 ,
C_ATTRIBUTE5 ,
C_ATTRIBUTE6 ,
C_ATTRIBUTE7 ,
C_ATTRIBUTE8 ,
C_ATTRIBUTE9 ,
C_ATTRIBUTE10 ,
C_ATTRIBUTE11 ,
C_ATTRIBUTE12 ,
C_ATTRIBUTE13 ,
C_ATTRIBUTE14 ,
C_ATTRIBUTE15 ,
C_ATTRIBUTE16 ,
C_ATTRIBUTE17 ,
C_ATTRIBUTE18 ,
C_ATTRIBUTE19 ,
C_ATTRIBUTE20 ,
D_ATTRIBUTE1 ,
D_ATTRIBUTE2 ,
D_ATTRIBUTE3 ,
D_ATTRIBUTE4 ,
D_ATTRIBUTE5 ,
D_ATTRIBUTE6 ,
D_ATTRIBUTE7 ,
D_ATTRIBUTE8 ,
D_ATTRIBUTE9 ,
D_ATTRIBUTE10 ,
N_ATTRIBUTE1 ,
N_ATTRIBUTE2 ,
N_ATTRIBUTE3 ,
N_ATTRIBUTE4 ,
N_ATTRIBUTE5 ,
N_ATTRIBUTE6 ,
N_ATTRIBUTE7 ,
N_ATTRIBUTE8 ,
N_ATTRIBUTE9 ,
N_ATTRIBUTE10 ,
STATUS_ID ,
TERRITORY_CODE ,
TIME_SINCE_NEW ,
CYCLES_SINCE_NEW ,
TIME_SINCE_OVERHAUL,
CYCLES_SINCE_OVERHAUL,
TIME_SINCE_REPAIR ,
CYCLES_SINCE_REPAIR ,
TIME_SINCE_VISIT ,
CYCLES_SINCE_VISIT ,
TIME_SINCE_MARK ,
CYCLES_SINCE_MARK ,
NUMBER_OF_REPAIRS
from mtl_serial_numbers_temp
where transaction_temp_id in ( select transaction_temp_id
from wms_material_txn_trace
where transaction_header_id = l_txn_header_id);
If (l_insert_serial_flag = 1 and l_insert_lot_flag = 1) then
insert into wms_serial_numbers_trace
(
TRANSACTION_TEMP_ID ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_LOGIN ,
REQUEST_ID ,
PROGRAM_APPLICATION_ID ,
PROGRAM_ID ,
PROGRAM_UPDATE_DATE ,
VENDOR_SERIAL_NUMBER ,
VENDOR_LOT_NUMBER ,
FM_SERIAL_NUMBER ,
TO_SERIAL_NUMBER ,
SERIAL_PREFIX ,
ERROR_CODE ,
GROUP_HEADER_ID ,
PARENT_SERIAL_NUMBER ,
END_ITEM_UNIT_NUMBER ,
SERIAL_ATTRIBUTE_CATEGORY ,
ORIGINATION_DATE ,
C_ATTRIBUTE1 ,
C_ATTRIBUTE2 ,
C_ATTRIBUTE3 ,
C_ATTRIBUTE4 ,
C_ATTRIBUTE5 ,
C_ATTRIBUTE6 ,
C_ATTRIBUTE7 ,
C_ATTRIBUTE8 ,
C_ATTRIBUTE9 ,
C_ATTRIBUTE10 ,
C_ATTRIBUTE11 ,
C_ATTRIBUTE12 ,
C_ATTRIBUTE13 ,
C_ATTRIBUTE14 ,
C_ATTRIBUTE15 ,
C_ATTRIBUTE16 ,
C_ATTRIBUTE17 ,
C_ATTRIBUTE18 ,
C_ATTRIBUTE19 ,
C_ATTRIBUTE20 ,
D_ATTRIBUTE1 ,
D_ATTRIBUTE2 ,
D_ATTRIBUTE3 ,
D_ATTRIBUTE4 ,
D_ATTRIBUTE5 ,
D_ATTRIBUTE6 ,
D_ATTRIBUTE7 ,
D_ATTRIBUTE8 ,
D_ATTRIBUTE9 ,
D_ATTRIBUTE10 ,
N_ATTRIBUTE1 ,
N_ATTRIBUTE2 ,
N_ATTRIBUTE3 ,
N_ATTRIBUTE4 ,
N_ATTRIBUTE5 ,
N_ATTRIBUTE6 ,
N_ATTRIBUTE7 ,
N_ATTRIBUTE8 ,
N_ATTRIBUTE9 ,
N_ATTRIBUTE10 ,
STATUS_ID ,
TERRITORY_CODE ,
TIME_SINCE_NEW ,
CYCLES_SINCE_NEW ,
TIME_SINCE_OVERHAUL,
CYCLES_SINCE_OVERHAUL,
TIME_SINCE_REPAIR ,
CYCLES_SINCE_REPAIR ,
TIME_SINCE_VISIT ,
CYCLES_SINCE_VISIT ,
TIME_SINCE_MARK ,
CYCLES_SINCE_MARK ,
NUMBER_OF_REPAIRS
)
select
TRANSACTION_TEMP_ID ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_LOGIN ,
REQUEST_ID ,
PROGRAM_APPLICATION_ID ,
PROGRAM_ID ,
PROGRAM_UPDATE_DATE ,
VENDOR_SERIAL_NUMBER ,
VENDOR_LOT_NUMBER ,
FM_SERIAL_NUMBER ,
TO_SERIAL_NUMBER ,
SERIAL_PREFIX ,
ERROR_CODE ,
GROUP_HEADER_ID ,
PARENT_SERIAL_NUMBER ,
END_ITEM_UNIT_NUMBER ,
SERIAL_ATTRIBUTE_CATEGORY ,
ORIGINATION_DATE ,
C_ATTRIBUTE1 ,
C_ATTRIBUTE2 ,
C_ATTRIBUTE3 ,
C_ATTRIBUTE4 ,
C_ATTRIBUTE5 ,
C_ATTRIBUTE6 ,
C_ATTRIBUTE7 ,
C_ATTRIBUTE8 ,
C_ATTRIBUTE9 ,
C_ATTRIBUTE10 ,
C_ATTRIBUTE11 ,
C_ATTRIBUTE12 ,
C_ATTRIBUTE13 ,
C_ATTRIBUTE14 ,
C_ATTRIBUTE15 ,
C_ATTRIBUTE16 ,
C_ATTRIBUTE17 ,
C_ATTRIBUTE18 ,
C_ATTRIBUTE19 ,
C_ATTRIBUTE20 ,
D_ATTRIBUTE1 ,
D_ATTRIBUTE2 ,
D_ATTRIBUTE3 ,
D_ATTRIBUTE4 ,
D_ATTRIBUTE5 ,
D_ATTRIBUTE6 ,
D_ATTRIBUTE7 ,
D_ATTRIBUTE8 ,
D_ATTRIBUTE9 ,
D_ATTRIBUTE10 ,
N_ATTRIBUTE1 ,
N_ATTRIBUTE2 ,
N_ATTRIBUTE3 ,
N_ATTRIBUTE4 ,
N_ATTRIBUTE5 ,
N_ATTRIBUTE6 ,
N_ATTRIBUTE7 ,
N_ATTRIBUTE8 ,
N_ATTRIBUTE9 ,
N_ATTRIBUTE10 ,
STATUS_ID ,
TERRITORY_CODE ,
TIME_SINCE_NEW ,
CYCLES_SINCE_NEW ,
TIME_SINCE_OVERHAUL,
CYCLES_SINCE_OVERHAUL,
TIME_SINCE_REPAIR ,
CYCLES_SINCE_REPAIR ,
TIME_SINCE_VISIT ,
CYCLES_SINCE_VISIT ,
TIME_SINCE_MARK ,
CYCLES_SINCE_MARK ,
NUMBER_OF_REPAIRS
from mtl_serial_numbers_temp
where transaction_temp_id in ( select wtlt.serial_transaction_temp_id
from wms_material_txn_trace wmtt,
wms_transaction_lots_trace wtlt
where wmtt.transaction_header_id = l_txn_header_id
and wmtt.transaction_temp_id = wtlt.transaction_temp_id);
End insert_txn_trace_rows;
select header_id,
strategy_id,
object_id,
type_code,
pick_header_id,
creation_date
from wms_rule_trace_headers
where move_order_line_id = p_move_order_line_id
and to_char(creation_date, 'HH:MI:SS') = to_char(p_trace_date, 'HH:MI:SS')
and simulation_mode = 'N'
order by type_code ;