APPS.OZF_AR_VALIDATION_PVT SQL Statements

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

Line: 36

    SELECT source_object_id
    ,      source_object_line_id
    ,      credit_to
    ,      SUM(quantity) qty
    ,      AVG(rate)  rate
    ,      SUM(NVL(claim_currency_amount,0)) amount
    FROM ozf_claim_lines
    WHERE claim_id = cv_claim_id
    GROUP BY source_object_id, source_object_line_id, credit_to;

Line: 48

    SELECT COUNT(rec.cash_receipt_id)
    FROM ar_receivable_applications rec
    WHERE rec.applied_customer_trx_id = cv_invoice_id
    AND   rec.cash_receipt_id = cv_receipt_id
    AND rec.display = 'Y';

Line: 171

   SELECT payment_schedule_id
   ,      trx_number
   ,      amount_line_items_remaining
   ,      tax_remaining
   ,      freight_remaining
   FROM ar_payment_schedules
   WHERE customer_trx_id = cv_customer_trx_id;

Line: 253

  SELECT  source_object_id, SUM(NVL(claim_currency_amount,0))
  FROM ozf_claim_lines
  WHERE claim_id = cv_claim_id
  AND ( cv_invoice_id IS NULL OR source_object_id = cv_invoice_id )
  GROUP BY source_object_id;

Line: 260

   SELECT source_object_id
   ,      credit_to
   ,      SUM(NVL(claim_currency_amount,0))
   FROM  ozf_claim_lines
   WHERE claim_id = cv_claim_id
   AND   source_object_class IN ('INVOICE', 'DM', 'CB')
   AND ( cv_invoice_id IS NULL OR source_object_id = cv_invoice_id )
   GROUP BY source_object_id, credit_to;

Line: 270

   SELECT source_object_id
   ,      source_object_line_id
   ,      SUM(NVL(claim_currency_amount,0))
   FROM ozf_claim_lines
   WHERE claim_id = cv_claim_id
   AND ( cv_invoice_id IS NULL OR source_object_id = cv_invoice_id )
   GROUP BY source_object_id,source_object_line_id;

Line: 279

   SELECT extended_amount
   FROM   ra_customer_trx_lines
   WHERE  customer_trx_line_id = cv_invoice_line_id;

Line: 284

   SELECT trx_number from ar_payment_schedules_all
   WHERE  customer_trx_id = cv_customer_trx_id;

Line: 430

  SELECT NVL(SUM(claim_currency_amount), 0)
  FROM ozf_claim_lines
  WHERE claim_id = cv_claim_id;

Line: 435

  SELECT batch_source_id
  ,      post_to_gl
  ,      gl_rec_clearing_account
  ,      cm_trx_type_id
  ,      billback_trx_type_id
  ,      cb_trx_type_id
  ,      adj_rec_trx_id
  ,      wo_rec_trx_id
  ,      neg_wo_rec_trx_id
  FROM ozf_sys_parameters
  WHERE set_of_books_id = cv_set_of_books_id;

Line: 448

  SELECT billback_trx_type_id, cm_trx_type_id
  FROM ozf_sys_parameters
  WHERE set_of_books_id = cv_set_of_books_id;

Line: 453

  SELECT type, creation_sign
  FROM ra_cust_trx_types
  WHERE cust_trx_type_id = cv_trx_type_id;

Line: 458

  SELECT reason_code
  ,      adjustment_reason_code
  ,      name
  FROM   ozf_reason_codes_vl
  WHERE  reason_code_id = cv_reason_code_id;

Line: 465

   SELECT cm_trx_type_id
   ,      dm_trx_type_id
   ,      cb_trx_type_id
   ,      wo_rec_trx_id
   ,      neg_wo_rec_trx_id
   ,      adj_rec_trx_id
   FROM ozf_claim_types_vl
   WHERE claim_type_id = cv_claim_type_id;

Line: 475

   SELECT SUM(amount_due_remaining),
          invoice_currency_code
   FROM ar_payment_schedules
   WHERE customer_trx_id = cv_customer_trx_id
   GROUP BY invoice_currency_code;

Line: 482

  SELECT item_id
  ,      quantity_uom
  --,      org_id
  ,      FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID')
  FROM ozf_claim_lines
  WHERE item_type = 'PRODUCT'
  AND claim_id = cv_claim_id;

Line: 491

  SELECT primary_uom_code
  FROM mtl_system_items
  WHERE inventory_item_id = cv_item_id
  AND organization_id = cv_org_id;

Line: 497

  SELECT uom_class
  FROM mtl_units_of_measure
  WHERE uom_code = cv_uom_code;

Line: 502

  SELECT salesrep_required_flag
  FROM ar_system_parameters;

Line: 506

  SELECT  source_object_id, source_object_class, SUM(NVL(claim_currency_amount,0))
  FROM ozf_claim_lines
  WHERE claim_id = cv_claim_id
  GROUP BY source_object_id, source_object_class;