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: 411

select parameter_value from oe_sys_parameters_all
where parameter_code = 'OE_DISCOUNT_DETAILS_ON_INVOICE' and org_id = mo_global.get_current_org_id;

Line: 415

  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: 423

  SELECT ra.inventory_item_id
       , ol.unit_selling_price
       , ra.uom_code
  FROM ra_customer_trx_lines_all ra,
       oe_order_lines_all ol
  WHERE ra.customer_trx_line_id = cv_customer_trx_line_id
    AND ra.interface_line_attribute6 = ol.line_id;

Line: 537

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

Line: 617

  SELECT order_type_id
  FROM ozf_reason_codes_vl
  WHERE reason_code_id = cv_reason_code_id;

Line: 622

  SELECT order_type_id
  FROM ozf_claim_types_vl
  WHERE claim_type_id = cv_claim_type_id;

Line: 627

  SELECT order_type_id
  FROM ozf_sys_parameters
  WHERE set_of_books_id = cv_set_of_books_id;

Line: 713

  SELECT cust_account_id
  ,      currency_code
  FROM ozf_claims
  WHERE claim_id = p_claim_id;

Line: 849

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

Line: 856

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

Line: 862

  SELECT rate
  FROM ozf_claim_lines
  WHERE claim_line_id = cv_claim_line_id;

Line: 1276

   SELECT interface_header_context
   FROM ra_customer_trx_all
   WHERE customer_trx_id = cv_customer_trx_id;

Line: 1281

  SELECT ordered_quantity
  FROM oe_order_lines_all
  WHERE header_id = cv_header_id;

Line: 1286

   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: 1295

  SELECT interface_header_attribute1
  FROM ra_customer_trx_all
  WHERE customer_trx_id =  cv_cust_id;

Line: 1300

  SELECT header_id
  FROM oe_order_headers_all
  WHERE order_number = cv_customer_trx;

Line: 1305

  SELECT interface_line_attribute6
  FROM ra_customer_trx_lines_all
  WHERE customer_trx_line_id =  cv_line_id;

Line: 1445

  SELECT quantity_invoiced
  ,      inventory_item_id
  FROM ra_customer_trx_lines
  WHERE customer_trx_line_id = cv_invoice_line_id;

Line: 1451

  SELECT ordered_quantity
  ,      inventory_item_id
  FROM oe_order_lines
  WHERE line_id = cv_order_line_id;

Line: 1457

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

Line: 1590

  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;