APPS.MISC_TRANSACTIONS_UTIL SQL Statements

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

Line: 31

   SELECT Nvl(stock_locator_control_code, -1), primary_cost_method, Nvl(NEGATIVE_INV_RECEIPT_CODE, -1)
    INTO x_stock_locator_control_code, x_primary_cost_method, l_tmp_num
    FROM mtl_parameters
    WHERE organization_id = p_organization_id;

Line: 50

     SELECT Nvl(disposition_id, -1)
      INTO x_account_disposition_id
      FROM mtl_generic_dispositions_kfv
      WHERE concatenated_segments = p_account_segments
       AND organization_id = p_organization_id;

Line: 93

   SELECT mtl_material_transactions_s.nextval
    INTO x_transaction_header_id
    FROM DUAL;