[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
X_last_update_date DATE,
X_last_updated_by NUMBER,
X_creation_date DATE,
X_created_by NUMBER,
X_last_update_login NUMBER,
X_description VARCHAR2,
X_status_type NUMBER,
X_primary_item_id NUMBER,
X_firm_planned_flag NUMBER,
X_job_type NUMBER,
X_wip_supply_type NUMBER,
X_class_code VARCHAR2,
X_material_account NUMBER,
X_material_overhead_account NUMBER,
X_resource_account NUMBER,
X_outside_processing_account NUMBER,
X_material_variance_account NUMBER,
X_resource_variance_account NUMBER,
X_outside_proc_var_account NUMBER,
X_std_cost_adjustment_account NUMBER,
X_overhead_account NUMBER,
X_overhead_variance_account NUMBER,
X_scheduled_start_date DATE,
X_date_released DATE,
X_scheduled_completion_date DATE,
X_date_completed DATE,
X_date_closed DATE,
X_start_quantity NUMBER,
X_overcompletion_toleran_type NUMBER,
X_overcompletion_toleran_value NUMBER,
X_quantity_completed NUMBER,
X_quantity_scrapped NUMBER,
X_net_quantity NUMBER,
X_bom_reference_id NUMBER,
X_routing_reference_id NUMBER,
X_common_bom_sequence_id NUMBER,
X_common_routing_sequence_id NUMBER,
X_bom_revision VARCHAR2,
X_routing_revision VARCHAR2,
X_bom_revision_date DATE,
X_routing_revision_date DATE,
X_lot_number VARCHAR2,
X_alternate_bom_designator VARCHAR2,
X_alternate_routing_designator VARCHAR2,
X_completion_subinventory VARCHAR2,
X_completion_locator_id NUMBER,
X_demand_class VARCHAR2,
X_attribute_category VARCHAR2,
X_attribute1 VARCHAR2,
X_attribute2 VARCHAR2,
X_attribute3 VARCHAR2,
X_attribute4 VARCHAR2,
X_attribute5 VARCHAR2,
X_attribute6 VARCHAR2,
X_attribute7 VARCHAR2,
X_attribute8 VARCHAR2,
X_attribute9 VARCHAR2,
X_attribute10 VARCHAR2,
X_attribute11 VARCHAR2,
X_attribute12 VARCHAR2,
X_attribute13 VARCHAR2,
X_attribute14 VARCHAR2,
X_attribute15 VARCHAR2,
X_end_item_unit_number VARCHAR2,
X_Schedule_Group_Id NUMBER,
X_Build_Sequence NUMBER,
X_Line_Id NUMBER,
X_Project_Id NUMBER,
X_Task_Id NUMBER,
X_priority NUMBER,
X_due_date DATE,
X_due_date_penalty NUMBER,
X_due_date_tolerance NUMBER,
X_requested_start_date DATE,
x_serialization_start_op NUMBER := null)
/*X_Project_Costed NUMBER)*/
IS
CURSOR C IS
SELECT wip_entity_id, organization_id, description,
status_type, primary_item_id, firm_planned_flag, job_type,
wip_supply_type, class_code, material_account, material_overhead_account
,resource_account ,outside_processing_account ,material_variance_account
,resource_variance_account ,outside_proc_variance_account ,std_cost_adjustment_account
,overhead_account ,overhead_variance_account ,scheduled_start_date
,date_released ,scheduled_completion_date ,date_completed
,date_closed ,start_quantity ,overcompletion_tolerance_type
,overcompletion_tolerance_value,quantity_completed
,quantity_scrapped ,net_quantity , bom_reference_id
,routing_reference_id ,common_bom_sequence_id ,common_routing_sequence_id
,bom_revision ,routing_revision ,bom_revision_date
,routing_revision_date ,lot_number ,alternate_bom_designator
,alternate_routing_designator ,completion_subinventory ,completion_locator_id
,demand_class ,attribute_category ,attribute1 ,attribute2 ,attribute3
,attribute4 ,attribute5 ,attribute6 ,attribute7 ,attribute8
,attribute9 ,attribute10 ,attribute11 ,attribute12 ,attribute13
,attribute14 ,attribute15, end_item_unit_number, schedule_group_id, build_sequence, line_id
,project_id, task_id, priority, due_date
,due_date_penalty, due_date_tolerance, requested_start_date, serialization_start_op /*project_costed*/
FROM WIP_DISCRETE_JOBS
WHERE rowid = X_Row_id
FOR UPDATE of Wip_Entity_Id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');