The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT btc.billing_category,
sum(rel.item_Cost * ed.quantity_required) TotalCost -- sangita
FROM CSD_REPAIR_ESTIMATE_LINES rel, CS_ESTIMATE_DETAILS ed,
CS_BILLING_TYPE_CATEGORIES btc, CS_TXN_BILLING_TYPES btt
WHERE rel.repair_estimate_id = p_repair_estimate_id
AND rel.estimate_detail_id = ed.estimate_detail_id
AND ed.txn_billing_type_id = btt.txn_billing_type_id
AND btc.billing_type = btt.billing_type
GROUP BY btc.billing_category;
SELECT count(rel.estimate_detail_id)
FROM CSD_REPAIR_ESTIMATE_LINES rel
WHERE rel.repair_estimate_id = p_repair_estimate_id
AND rel.item_cost IS NULL
AND rownum = 1;
SELECT count(repair_estimate_line_id)
FROM CSD_REPAIR_ESTIMATE_LINES
WHERE repair_estimate_id = p_repair_estimate_id
ANd rownum=1;
FND_MESSAGE.SET_NAME('CSD', 'CSD_CST_NO_CHG_ROWS_SELECTED');
SELECT count(repair_estimate_line_id)
FROM CSD_REPAIR_ESTIMATE_LINES
WHERE repair_estimate_id = p_repair_estimate_id;
SELECT btc.billing_category,
sum(nvl(ed.after_warranty_cost, 0)) TotalCharges
FROM CSD_REPAIR_ESTIMATE_LINES rel, CS_ESTIMATE_DETAILS ed,
CS_BILLING_TYPE_CATEGORIES btc, CS_TXN_BILLING_TYPES btt
WHERE rel.repair_estimate_id = p_repair_estimate_id
AND rel.estimate_detail_id = ed.estimate_detail_id
AND ed.txn_billing_type_id = btt.txn_billing_type_id
AND btc.billing_type = btt.billing_type
GROUP BY btc.billing_category;
FND_MESSAGE.SET_NAME('CSD', 'CSD_CST_NO_CHG_ROWS_SELECTED');
SELECT CIC.item_cost
FROM CST_ITEM_COSTS CIC
WHERE CIC.inventory_item_id = p_inventory_item_id
AND CIC.organization_id = p_organization_id
AND CIC.cost_type_id = 1; -- standard/frozen cost
SELECT primary_uom_code
FROM mtl_system_items MSI
WHERE MSI.inventory_item_id = p_inventory_item_id
AND MSI.organization_id = p_organization_id;
SELECT CIC.item_cost
FROM CST_ITEM_COSTS CIC
WHERE CIC.inventory_item_id = p_inventory_item_id
AND CIC.organization_id = p_organization_id
AND CIC.cost_type_id = 1; -- standard/frozen cost
SELECT CRC.resource_rate
FROM cst_resource_costs CRC
WHERE CRC.resource_id = p_bom_resource_id
AND CRC.organization_id = p_organization_id
AND CRC.cost_type_id = 1; -- standard/frozen cost
SELECT BR.unit_of_measure
FROM BOM_RESOURCES BR
WHERE BR.resource_id = p_bom_resource_id;