[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT instance_id, serial_number,mass_ro_sn_id
FROM csd_mass_ro_sn
WHERE repair_line_id = p_repln_id;
SELECT inventory_item_id, status, quantity
FROM csd_repairs
WHERE repair_line_id = p_repln_id;
csd_repairs_pvt.delete_repair_order
(p_api_version_number => 1.0,
p_init_msg_list => fnd_api.g_false,
p_commit => fnd_api.g_false,
p_validation_level => fnd_api.g_valid_level_full,
p_repair_line_id => p_repair_order_line_id,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
UPDATE csd_repairs
SET quantity = quantity - l_count_sn_success,
last_update_date = SYSDATE,
last_update_login = fnd_global.login_id,
last_updated_by = fnd_global.user_id
WHERE repair_line_id = p_repair_order_line_id;
SELECT repair_type_ref
FROM csd_repair_types_vl
WHERE repair_type_id = p_repair_type_id;
SELECT incident_id, inventory_item_id,
customer_product_id, unit_of_measure, repair_type_id,
owning_organization_id, -- swai: bug 7565999
resource_id, project_id, task_id, contract_line_id,
auto_process_rma, repair_mode, item_revision,
NULL instance_id, status_reason_code,
approval_required_flag, approval_status, promise_date,
1 quantity, currency_code, default_po_num, ro_txn_status, --added DEFAULT_PO_NUM, bug#9206256
problem_description, ro_priority_code, ro_warranty_status_code, escalation_code, --yvchen: bug 12797168
original_source_reference, NULL serial_number, 'O' status,
-- Added below cols when dff support is added
0 wip_quantity, 0 quantity_rcvd, 0 quantity_shipped,
attribute_category, attribute1, attribute2,
attribute3, attribute4, attribute5,
attribute6, attribute7, attribute8,
attribute9, attribute10, attribute11,
attribute12, attribute13, attribute14, attribute15,
original_source_header_id, original_source_line_id,
price_list_header_id, inventory_org_id, --bug#6415265
attribute16,attribute17,attribute18, -- bug#7497907, 12.1 FP, subhat
attribute19,attribute20,attribute21,attribute22,attribute23,
attribute24,attribute25,attribute26,attribute27,attribute28,attribute29,
attribute30
FROM csd_repairs
WHERE repair_line_id = p_repln_id;
csd_mass_ro_sn_pkg.delete_row (p_mass_ro_sn_id => p_mass_ro_sn_id);
SELECT customer_id, account_id
FROM cs_incidents_all_b
WHERE incident_id = p_incident_id;
SELECT cov.actual_coverage_id,
-- cov.coverage_name, -- commented for bugfix 3617932
ent.txn_group_id
FROM oks_ent_coverages_v cov, oks_ent_txn_groups_v ent
WHERE cov.contract_line_id = p_product_txn_rec.contract_id
AND cov.actual_coverage_id = ent.coverage_id
AND ent.business_process_id = p_bus_process_id;
SELECT incident_id, original_source_reference,
original_source_header_id, original_source_line_id
FROM csd_repairs
WHERE repair_line_id = p_repair_line_id;
SELECT currency_code
FROM oe_price_lists
WHERE price_list_id = p_price_list_id;
SELECT oot.order_category_code
FROM oe_order_headers_all ooh, oe_order_types_v oot
WHERE ooh.order_type_id = oot.order_type_id
AND ooh.header_id = p_header_id;
SELECT cust_po_number
FROM oe_order_headers_all
WHERE header_id = p_orig_src_header_id
AND cust_po_number = p_po_number;
SELECT ced.purchase_order_num
FROM csd_product_transactions cpt, cs_estimate_details ced
WHERE cpt.estimate_detail_id = ced.estimate_detail_id
AND cpt.repair_line_id = p_repair_line_id
AND ced.order_header_id = p_order_header_id
AND ced.purchase_order_num = p_po_number;
SELECT MAX (ced.order_header_id)
FROM csd_repairs cr,
csd_product_transactions cpt,
cs_estimate_details ced
WHERE cr.incident_id = p_incident_id
AND cpt.repair_line_id = cr.repair_line_id
AND ced.estimate_detail_id = cpt.estimate_detail_id
AND ced.order_header_id IS NOT NULL
AND ced.interface_to_oe_flag = 'Y';
SELECT 'x'
FROM mtl_secondary_inventories
WHERE secondary_inventory_name = p_sub_inventory
AND organization_id = p_ship_from_org_id;
SELECT picking_rule_id
FROM wsh_picking_rules
WHERE picking_rule_id = p_picking_rule_id;
SELECT released_status
FROM wsh_delivery_details
WHERE source_line_id = p_order_line_id;
SELECT transaction_type_id
FROM cs_txn_billing_types
WHERE txn_billing_type_id = p_txn_billing_type_id;
csd_product_transactions_pkg.insert_row
(px_product_transaction_id => p_product_txn_rec.product_transaction_id,
p_repair_line_id => p_product_txn_rec.repair_line_id,
p_estimate_detail_id => l_estimate_detail_id,
p_action_type => p_product_txn_rec.action_type,
p_action_code => p_product_txn_rec.action_code,
p_lot_number => p_product_txn_rec.lot_number,
-- Following parameter is not used from 11.5.10 release
-- p_SHIPPED_SERIAL_NUMBER => p_product_txn_rec.SHIPPED_SERIAL_NUMBER,
p_sub_inventory => p_product_txn_rec.sub_inventory,
p_interface_to_om_flag => p_product_txn_rec.interface_to_om_flag,
p_book_sales_order_flag => p_product_txn_rec.book_sales_order_flag,
p_release_sales_order_flag => p_product_txn_rec.release_sales_order_flag,
p_ship_sales_order_flag => p_product_txn_rec.ship_sales_order_flag,
p_prod_txn_status => p_product_txn_rec.prod_txn_status,
p_prod_txn_code => p_product_txn_rec.prod_txn_code,
p_last_update_date => SYSDATE,
p_creation_date => SYSDATE,
p_last_updated_by => fnd_global.user_id,
p_created_by => fnd_global.user_id,
p_last_update_login => fnd_global.user_id,
p_attribute1 => p_product_txn_rec.attribute1,
p_attribute2 => p_product_txn_rec.attribute2,
p_attribute3 => p_product_txn_rec.attribute3,
p_attribute4 => p_product_txn_rec.attribute4,
p_attribute5 => p_product_txn_rec.attribute5,
p_attribute6 => p_product_txn_rec.attribute6,
p_attribute7 => p_product_txn_rec.attribute7,
p_attribute8 => p_product_txn_rec.attribute8,
p_attribute9 => p_product_txn_rec.attribute9,
p_attribute10 => p_product_txn_rec.attribute10,
p_attribute11 => p_product_txn_rec.attribute11,
p_attribute12 => p_product_txn_rec.attribute12,
p_attribute13 => p_product_txn_rec.attribute13,
p_attribute14 => p_product_txn_rec.attribute14,
p_attribute15 => p_product_txn_rec.attribute15,
p_context => p_product_txn_rec.CONTEXT,
p_object_version_number => 1,
p_req_header_id => p_product_txn_rec.req_header_id,
p_req_line_id => p_product_txn_rec.req_line_id,
p_order_header_id => p_product_txn_rec.order_header_id,
p_order_line_id => p_product_txn_rec.order_line_id,
p_prd_txn_qty_received => p_product_txn_rec.prd_txn_qty_received,
p_prd_txn_qty_shipped => p_product_txn_rec.prd_txn_qty_shipped,
p_source_serial_number => p_product_txn_rec.source_serial_number,
p_source_instance_id => p_product_txn_rec.source_instance_id,
p_non_source_serial_number => p_product_txn_rec.non_source_serial_number,
p_non_source_instance_id => p_product_txn_rec.non_source_instance_id,
p_locator_id => p_product_txn_rec.locator_id,
p_sub_inventory_rcvd => p_product_txn_rec.sub_inventory_rcvd,
p_lot_number_rcvd => p_product_txn_rec.lot_number_rcvd,
p_picking_rule_id => p_product_txn_rec.picking_rule_id,
p_project_id => p_product_txn_rec.project_id,
p_task_id => p_product_txn_rec.task_id,
p_unit_number => p_product_txn_rec.unit_number);
UPDATE csd_repairs
SET ro_txn_status = l_ro_txn_status
WHERE repair_line_id = p_product_txn_rec.repair_line_id;
fnd_message.set_name ('CSD', 'CSD_ERR_REPAIRS_UPDATE');
UPDATE csd_product_transactions
SET prod_txn_status = l_prod_txn_status
WHERE product_transaction_id = p_product_txn_rec.product_transaction_id;
fnd_message.set_name ('CSD', 'CSD_ERR_PRD_TXN_UPDATE');
SELECT party_site_id
INTO l_party_site_id
FROM hz_party_site_uses
WHERE party_site_use_id = px_instance_rec.party_site_use_id;
SELECT 'X'
INTO l_check
FROM fnd_lookups
WHERE lookup_type = 'CSD_PRODUCT_TXN_STATUS'
AND lookup_code = p_product_txn_rec.prod_txn_status;
SELECT serial_number_control_code
INTO l_serial_code
FROM mtl_system_items
WHERE inventory_item_id = p_inv_item_id
AND organization_id = cs_std.get_item_valdn_orgzn_id;
SELECT NVL (comms_nl_trackable_flag, 'N')
INTO l_ib_trackable_flag
FROM mtl_system_items
WHERE inventory_item_id = p_inv_item_id
AND organization_id = cs_std.get_item_valdn_orgzn_id;
SELECT booked_flag
FROM oe_order_headers_all
WHERE header_id = p_header_id;
SELECT a.order_header_id, a.order_line_id
FROM cs_estimate_details a
WHERE a.estimate_detail_id = p_est_detial_id
AND a.order_header_id IS NOT NULL;
SELECT ship_from_org_id, unit_selling_price, org_id
FROM oe_order_lines_all
WHERE line_id = p_order_line_id;