APPS.OZF_OM_VALIDATION_PVT SQL Statements

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

Line: 116

      OZF_ORDER_PRICE_PVT.G_LINE_REC_TBL.delete();

Line: 406

  SELECT inventory_item_id
  ,      unit_selling_price
  ,      uom_code
  FROM ra_customer_trx_lines
  WHERE customer_trx_line_id = cv_customer_trx_line_id;

Line: 478

  SELECT inventory_item_id
  ,      unit_selling_price
  ,      order_quantity_uom
  FROM oe_order_lines
  WHERE line_id = cv_order_line_id;

Line: 558

  SELECT order_type_id
  FROM ozf_reason_codes_vl
  WHERE reason_code_id = cv_reason_code_id;

Line: 563

  SELECT order_type_id
  FROM ozf_claim_types_vl
  WHERE claim_type_id = cv_claim_type_id;

Line: 568

  SELECT order_type_id
  FROM ozf_sys_parameters
  WHERE set_of_books_id = cv_set_of_books_id;

Line: 654

  SELECT cust_account_id
  ,      currency_code
  FROM ozf_claims
  WHERE claim_id = p_claim_id;

Line: 790

  SELECT cust_account_id
  ,      order_type_id
  ,      currency_code
  FROM ozf_claims
  WHERE claim_id = p_claim_id;

Line: 797

  SELECT description
  FROM mtl_system_items_vl
  WHERE inventory_item_id = cv_item_id
  AND organization_id = cv_org_id;

Line: 803

  SELECT rate
  FROM ozf_claim_lines
  WHERE claim_line_id = cv_claim_line_id;

Line: 1214

   SELECT interface_header_context
   FROM ra_customer_trx_all
   WHERE customer_trx_id = cv_customer_trx_id;

Line: 1219

  SELECT ordered_quantity
  FROM oe_order_lines_all
  WHERE header_id = cv_header_id;

Line: 1224

   SELECT   sum(nvl(ordered_quantity, 0))
   FROM   oe_order_lines_all
   WHERE  reference_header_id = cv_header_id
   AND reference_line_id = cv_line_id
   AND    booked_flag = 'Y'
   AND    cancelled_flag <> 'Y'
   AND    line_category_code = 'RETURN';

Line: 1233

  SELECT interface_header_attribute1
  FROM ra_customer_trx_all
  WHERE customer_trx_id =  cv_cust_id;

Line: 1238

  SELECT header_id
  FROM oe_order_headers_all
  WHERE order_number = cv_customer_trx;

Line: 1243

  SELECT interface_line_attribute6
  FROM ra_customer_trx_lines_all
  WHERE customer_trx_line_id =  cv_line_id;

Line: 1383

  SELECT quantity_invoiced
  ,      inventory_item_id
  FROM ra_customer_trx_lines
  WHERE customer_trx_line_id = cv_invoice_line_id;

Line: 1389

  SELECT ordered_quantity
  ,      inventory_item_id
  FROM oe_order_lines
  WHERE line_id = cv_order_line_id;

Line: 1395

  SELECT description
  FROM mtl_system_items_vl
  WHERE inventory_item_id = cv_item_id
  AND organization_id = cv_org_id;

Line: 1528

  SELECT invoice_enabled_flag
  ,      invoiceable_item_flag
  ,      returnable_flag
  ,      description
  FROM mtl_system_items_vl
  WHERE inventory_item_id = cv_item_id
  AND organization_id = cv_org_id;