APPS.INV_ONHAND_BALANCE SQL Statements

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

Line: 38

  update_history      EXCEPTION;

Line: 82

      SELECT trading_partner_site_id
      INTO l_Party_Site_ID
      FROM mtl_client_parameters
      WHERE client_id IN (SELECT cust_account_id
                          FROM hz_cust_accounts
                          WHERE party_id = P_txn_hist_record.trading_partner_id);

Line: 221

     INV_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,
                                                                l_xml_document_id,
                                                                l_txns_id,
                                                                l_return_status );

Line: 236

          RAISE update_history;

Line: 270

  WHEN update_history THEN
     x_return_status := rcv_error_pkg.g_ret_sts_error;

Line: 273

       inv_trx_util_pub.TRACE('update_history exception has occured.', 'INV_ONHAND_BALANCE', 9);

Line: 332

      SELECT po_wf_itemkey_s.NEXTVAL
      INTO   l_orig_Event_Key
      FROM   DUAL;

Line: 356

      SELECT party_id
      INTO l_party_id
      FROM hz_cust_accounts
      WHERE cust_account_id IN (SELECT client_id
                                FROM mtl_client_parameters
                                WHERE client_code = P_client_code);

Line: 364

      select location_id
      into l_party_id
      from hr_organization_units_v
      where organization_id = P_Org_ID
      and rownum = 1;

Line: 386

      /* Raise event will insert the record into the transaction history table
         for the current transaction.
      */

      Raise_Event ( l_curr_txn_hist_record,
                    l_xml_document_id,
                    l_Return_Status );

Line: 460

l_select_stmt       VARCHAR2(2000);

Line: 462

l_insert_stmt       VARCHAR2(2000);

Line: 487

  delete from MTL_LSP_ONHAND_BALANCE_TMP;

Line: 489

     inv_trx_util_pub.TRACE('Initialize, rows deleted : '||sql%rowcount, 'INV_ONHAND_BALANCE', 9);

Line: 495

             inv_trx_util_pub.TRACE('Exception : '||sqlerrm||' occurred in delete_temp_table', 'INV_ONHAND_BALANCE', 9);

Line: 509

    select  mtl_txns_history_s.nextval
    into l_entity_id
    from dual;

Line: 524

  l_insert_stmt :='insert into MTL_LSP_ONHAND_BALANCE_TMP(ITEM_ID, ITEM, ITEM_DESCRIPTION, PRIMARY_UOM, PRIMARY_QUANTITY, SECONDARY_UOM, SECONDARY_QUANTITY, CATEGORY, CONTAINERIZED_FLAG, ONHAND_STATUS, SNAPSHOT_DATE, XML_DOCUMENT_ID ';

Line: 525

  l_select_stmt :='select item_id, item, ITEM_DESCRIPTION, PRIMARY_UOM, sum(PRIMARY_QUANTITY), SECONDARY_UOM, sum(SECONDARY_QUANTITY), CATEGORY, CONTAINERIZED_FLAG, ONHAND_STATUS, SNAPSHOT_DATE, '||l_xml_doc_id;

Line: 534

   l_insert_stmt :=l_insert_stmt||',WAREHOUSE, WAREHOUSE_ID ';

Line: 535

   l_select_stmt :=l_select_stmt||',WAREHOUSE, WAREHOUSE_ID ';

Line: 540

   l_insert_stmt :=l_insert_stmt||',WAREHOUSE, WAREHOUSE_ID,SUBINVENTORY ';

Line: 541

   l_select_stmt :=l_select_stmt||',WAREHOUSE, WAREHOUSE_ID,SUBINVENTORY ';

Line: 546

   l_insert_stmt :=l_insert_stmt||',WAREHOUSE, WAREHOUSE_ID,SUBINVENTORY,LOCATOR ';

Line: 547

   l_select_stmt :=l_select_stmt||',WAREHOUSE, WAREHOUSE_ID,SUBINVENTORY,LOCATOR ';

Line: 552

   l_insert_stmt :=l_insert_stmt||',LOT ';

Line: 553

   l_select_stmt :=l_select_stmt||',LOT ';

Line: 567

    l_where_stmt :=l_where_stmt||' and LOCATOR =(select concatenated_segments from mtl_item_locations_kfv where inventory_location_id='||p_locator||')';

Line: 573

  l_stmt := l_insert_stmt||') '||l_select_stmt||' from mtl_onhand_sync_v '||l_where_stmt||l_group_by;

Line: 575

  inv_trx_util_pub.TRACE('l_insert_stmt : '||l_insert_stmt, 'INV_ONHAND_BALANCE', 9);

Line: 576

  inv_trx_util_pub.TRACE('l_select_stmt : '||l_select_stmt, 'INV_ONHAND_BALANCE', 9);

Line: 584

     inv_trx_util_pub.TRACE('Rows inserted : '||sql%rowcount, 'INV_ONHAND_BALANCE', 9);