The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT bor.routing_sequence_id,
bor.routing_type, -- Eng_Routing_Flag
bor.common_assembly_item_id, --Common_Assembly_Item_Name
bor.routing_comment,
bor.completion_subinventory,
bor.completion_locator_id, -- Completion_Location_Name
wl.line_code,
bor.cfm_Routing_Flag,
bor.mixed_model_map_flag,
bor.priority,
bor.total_product_cycle_time, -- Total_Cycle_Time
bor.ctp_flag,
bor.attribute_category,
bor.attribute1,
bor.attribute2,
bor.attribute3,
bor.attribute4,
bor.attribute5,
bor.attribute6,
bor.attribute7,
bor.attribute8,
bor.attribute9,
bor.attribute10,
bor.attribute11,
bor.attribute12,
bor.attribute13,
bor.attribute14,
bor.attribute15,
bor.original_system_reference
--, bor.serialization_start_op
FROM bom_operational_routings bor,
wip_lines wl
WHERE bor.organization_id = P_organization_id
AND bor.assembly_item_id = P_item_id
AND NVL(bor.alternate_routing_designator,'##$$##') = NVL(P_alternate_routing_designator,'##$$##')
AND wl.line_id(+) = bor.line_id;
SELECT Process_Revision,
Effectivity_Date,
Attribute_category,
Attribute1,
Attribute2,
Attribute3,
Attribute4,
Attribute5,
Attribute6,
Attribute7,
Attribute8,
Attribute9,
Attribute10,
Attribute11,
Attribute12,
Attribute13,
Attribute14,
Attribute15
FROM mtl_rtg_item_revisions
WHERE inventory_item_id = p_item_id
AND organization_id = p_organization_id;
SELECT br.Resource_Code, -- Sub_Resource_Code
bsor.replacement_group_num, -- Replacement_Group_Number
ca.Activity,
bsor.Standard_Rate_Flag,
bsor.Assigned_Units,
bsor.Usage_Rate_Or_Amount,
bsor.Usage_Rate_Or_Amount_Inverse,
bsor.Basis_Type,
bsor.Schedule_Flag,
bsor.Resource_Offset_Percent,
bsor.Autocharge_Type,
bsor.Principle_Flag,
bsor.Attribute_category,
bsor.Attribute1,
bsor.Attribute2,
bsor.Attribute3,
bsor.Attribute4,
bsor.Attribute5,
bsor.Attribute6,
bsor.Attribute7,
bsor.Attribute8,
bsor.Attribute9,
bsor.Attribute10,
bsor.Attribute11,
bsor.Attribute12,
bsor.Attribute13,
bsor.Attribute14,
bsor.Attribute15,
bst.setup_Code -- Setup_Type
FROM bom_sub_operation_resources bsor,
bom_resources br,
cst_activities ca,
bom_setup_types bst
WHERE bsor.operation_sequence_id = P_operation_sequence_id
AND bsor.schedule_seq_num = P_schedule_seq_num
AND br.resource_id = bsor.resource_id
AND ca.activity_id(+) = bsor.activity_id
AND bst.setup_id(+) = bsor.setup_id;
SELECT bor.Resource_Seq_Num, -- Resource_Sequence_Number
br.Resource_Code,
ca.Activity,
bor.Standard_Rate_Flag,
bor.Assigned_Units,
bor.Usage_Rate_Or_amount,
bor.Usage_Rate_Or_Amount_Inverse,
bor.Basis_Type,
bor.Schedule_Flag,
bor.Resource_Offset_Percent,
bor.Autocharge_Type,
bor.Schedule_Seq_Num, -- Schedule_Sequence_Number
bor.Principle_Flag,
bor.Attribute_category,
bor.Attribute1,
bor.Attribute2,
bor.Attribute3,
bor.Attribute4,
bor.Attribute5,
bor.Attribute6,
bor.Attribute7,
bor.Attribute8,
bor.Attribute9,
bor.Attribute10,
bor.Attribute11,
bor.Attribute12,
bor.Attribute13,
bor.Attribute14,
bor.Attribute15,
bst.Setup_Code -- Setup_Type
FROM bom_operation_resources bor,
bom_resources br,
cst_activities ca,
bom_setup_types bst
WHERE bor.operation_sequence_id = P_operation_sequence_id
AND br.resource_id = bor.resource_id
AND ca.activity_id(+) = bor.activity_id
AND bst.setup_id(+) = bor.setup_id
ORDER BY
bor.schedule_seq_num;
SELECT Operation_Seq_Num,
operation_sequence_id,
Operation_Type,
Effectivity_Date,
Standard_Operation_Code,
Department_Code,
Operation_Lead_Time_Percent,
Minimum_Transfer_Quantity,
Count_Point_Type,
Operation_Description,
Disable_Date,
Backflush_Flag,
Option_Dependent_Flag,
Reference_Flag,
Process_Seq_Num,
Process_Code,
Line_Op_Seq_Num,
Line_Op_Code,
Yield,
Cumulative_Yield,
Reverse_Cumulative_Yield,
Labor_Time_User,
Machine_Time_User,
Total_Time_User,
Net_Planning_Percent,
Include_In_Rollup,
Operation_Yield_Enabled,
Attribute_category,
Attribute1,
Attribute2,
Attribute3,
Attribute4,
Attribute5,
Attribute6,
Attribute7,
Attribute8,
Attribute9,
Attribute10,
Attribute11,
Attribute12,
Attribute13,
Attribute14,
Attribute15,
Original_System_Reference
--,long_description
FROM bom_operation_sequences_v
WHERE routing_sequence_id = P_routing_seq_id;
SELECT bonv.From_Seq_Num,
bos1.X_Coordinate From_X_Coordinate,
bos1.Y_Coordinate From_Y_Coordinate,
bonv.From_Effectivity_Date,
bonv.To_Seq_Num,
bos2.X_Coordinate To_X_Coordinate,
bos2.Y_Coordinate To_Y_Coordinate,
bonv.To_Effectivity_Date,
bonv.Transition_Type,
bonv.Planning_Pct,
bonv.Attribute_category,
bonv.Attribute1,
bonv.Attribute2,
bonv.Attribute3,
bonv.Attribute4,
bonv.Attribute5,
bonv.Attribute6,
bonv.Attribute7,
bonv.Attribute8,
bonv.Attribute9,
bonv.Attribute10,
bonv.Attribute11,
bonv.Attribute12,
bonv.Attribute13,
bonv.Attribute14,
bonv.Attribute15,
bonv.Original_System_Reference
FROM bom_operation_networks_v bonv,
bom_operation_sequences bos1,
bom_operation_sequences bos2
WHERE bonv.routing_sequence_id = P_routing_seq_id
AND bos1.Operation_Sequence_Id = bonv.From_Op_Seq_Id
AND bos2.Operation_Sequence_Id = bonv.To_Op_Seq_Id;
G_rtg_revision_tbl.DELETE;
G_operation_tbl.DELETE;
G_op_resource_tbl.DELETE;
G_sub_resource_tbl.DELETE;
G_op_network_tbl.DELETE;