APPS.CSD_COST_ANALYSIS_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 63

        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;

Line: 77

      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;

Line: 87

       SELECT count(repair_estimate_line_id)
       FROM CSD_REPAIR_ESTIMATE_LINES
       WHERE repair_estimate_id = p_repair_estimate_id
       ANd rownum=1;

Line: 173

        FND_MESSAGE.SET_NAME('CSD', 'CSD_CST_NO_CHG_ROWS_SELECTED');

Line: 356

      SELECT count(repair_estimate_line_id)
        FROM CSD_REPAIR_ESTIMATE_LINES
       WHERE repair_estimate_id = p_repair_estimate_id;

Line: 363

        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;

Line: 436

        FND_MESSAGE.SET_NAME('CSD', 'CSD_CST_NO_CHG_ROWS_SELECTED');

Line: 875

      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

Line: 885

	   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;

Line: 1164

      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

Line: 1174

     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

Line: 1183

         SELECT BR.unit_of_measure
         FROM BOM_RESOURCES BR
         WHERE BR.resource_id = p_bom_resource_id;