APPS.INV_ITEM_ORG_ASSIGN_CP SQL Statements

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

Line: 113

SELECT
  chart_of_accounts_id
FROM
  gl_sets_of_books
, hr_organization_information
WHERE set_of_books_id                = org_information1
  AND upper(org_information_context) = upper('Accounting Information')
  AND organization_id                = c_organization_id;

Line: 126

SELECT
  code_combination_id
FROM
  gl_code_combinations
WHERE chart_of_accounts_id = c_chart_of_accounts_id
  AND code_combination_id  = c_code_combination_id
  AND nvl(start_date_active,SYSDATE) <= SYSDATE
  AND nvl(end_date_active,SYSDATE)   >= SYSDATE;

Line: 155

  x_valid_org_tbl.DELETE;

Line: 342

SELECT
  organization_id
, cost_of_sales_account
, encumbrance_account
, sales_account
, expense_account
, starting_revision
FROM
  mtl_parameters
WHERE organization_id = c_organization_id;

Line: 598

  x_item_cursor :=  'SELECT  msi.inventory_item_id'                        ||
                     ' FROM  mtl_system_items_b msi'                       ||
                             l_mcat_f                                      ||
                     ' WHERE msi.organization_id = :b_master_org_id  '    ||
                             l_mstk_w                                      ||
                             l_mcat_w1                                     ||
                             l_mcat_w2;

Line: 663

  SELECT  master_organization_id
    INTO  l_master_org_id
    FROM  mtl_parameters
    WHERE organization_id = p_org_hier_origin_id;

Line: 699

  SELECT  mtl_system_items_intf_sets_s.NEXTVAL
    INTO  l_set_process_id
    FROM  dual;

Line: 738

  SELECT  COUNT(*)
    INTO  l_count
    FROM  fnd_concurrent_requests
    WHERE request_id = p_request_id
      AND phase_code = 'C';

Line: 972

  x_filtered_org_tbl.DELETE;

Line: 977

      SELECT  COUNT(*)
        INTO  l_count
        FROM  mtl_system_items
        WHERE organization_id = p_org_tbl(l_Idx)
          AND inventory_item_id = p_inventory_item_id;

Line: 1025

  SELECT  COUNT(*)
    INTO  l_error_count
    FROM  mtl_system_items_interface
    WHERE request_id = FND_GLOBAL.conc_request_id
    /*AND process_flag = 4; Bug 5962957 Changing this to 1 since the records are passed in as process_flag 1*/

Line: 1343

SELECT
  msib.primary_uom_code  primary_uom_code
, msib.primary_unit_of_measure  primary_unit_of_measure
FROM
  mtl_system_items_b msib
, mtl_units_of_measure muom
WHERE msib.organization_id          =  c_master_org_id
  AND msib.inventory_item_id        =  c_inventory_item_id
  AND msib.primary_unit_of_measure  =  muom.unit_of_measure
  AND SYSDATE < nvl(muom.disable_date,SYSDATE+1);

Line: 1362

SELECT
  rowid
, inventory_item_id
, organization_id
, transaction_id
, set_process_id
FROM
  mtl_system_items_interface
WHERE set_process_id     = c_set_process_id
  AND inventory_item_id  = c_inventory_item_id
  AND organization_id    = c_organization_id
FOR UPDATE;

Line: 1449

    SELECT name
      INTO l_hierarchy_name
      FROM per_organization_structures
        WHERE organization_structure_id = p_org_hierarchy_id;

Line: 1455

    SELECT meaning
      INTO l_property
      FROM mfg_lookups
        WHERE lookup_type = 'INV_MGD_HIER_PROPERTY_TYPE'
          AND lookup_code = 1;

Line: 1764

          INSERT INTO mtl_system_items_interface
          ( process_flag
          , set_process_id
          , transaction_type
          , inventory_item_id
          , organization_id
          , primary_uom_code
          , primary_unit_of_measure
          , cost_of_sales_account
          , encumbrance_account
          , sales_account
          , expense_account
          , last_update_date
          , last_updated_by
          , creation_date
          , created_by
          , last_update_login
          , request_id
          , program_application_id
          , program_id
          , program_update_date
          )
          VALUES
          ( /*4 Bug 5962957 here the validation should happen so changing it to 1*/
	    1
          , l_set_process_id
          , 'CREATE'
          , l_inventory_item_id
          , l_filtered_org_tbl(l_Idx)
          , primary_uom_row.primary_uom_code
          , primary_uom_row.primary_unit_of_measure
          , get_cost_of_sales_account(l_filtered_org_tbl(l_Idx))
          , get_encumbrance_account(l_filtered_org_tbl(l_Idx))
          , get_sales_account(l_filtered_org_tbl(l_Idx))
          , get_expense_account(l_filtered_org_tbl(l_Idx))
          , SYSDATE
          , FND_GLOBAL.user_id
          , SYSDATE
          , FND_GLOBAL.user_id
          , FND_GLOBAL.login_id
          , FND_GLOBAL.conc_request_id
          , FND_GLOBAL.prog_appl_id
          , FND_GLOBAL.conc_program_id
          , SYSDATE
          );

Line: 1874

          INSERT INTO mtl_item_revisions_interface
          ( inventory_item_id
          , organization_id
          , revision
          , revision_label
          , implementation_date
          , effectivity_date
          , transaction_id
          , process_flag
          , transaction_type
          , set_process_id
          , last_update_date
          , last_updated_by
          , creation_date
          , created_by
          , last_update_login
          , request_id
          , program_application_id
          , program_id
          , program_update_date
          , revision_id
          )
          VALUES
          (items_interface_row.inventory_item_id
          ,items_interface_row.organization_id
          ,l_rev_label
          ,l_rev_label
          ,SYSDATE
          ,SYSDATE
          ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
          ,/*4 Bug 5962957 here the validation should happen so changing it to 1*/ 1
          ,'CREATE'
          ,l_set_process_id
          ,SYSDATE
          ,FND_GLOBAL.user_id
          ,SYSDATE
          ,FND_GLOBAL.user_id
          ,FND_GLOBAL.login_id
          ,FND_GLOBAL.conc_request_id
          ,FND_GLOBAL.prog_appl_id
          ,FND_GLOBAL.conc_program_id
          ,SYSDATE
          ,MTL_ITEM_REVISIONS_B_S.nextval
          );

Line: 1963

              , 'Interface records inserted for Item:' || l_inventory_item_id
                || ' '|| 'Process Id:'|| l_set_process_id
              );