APPS.CSI_INV_TXN_HOOK_PKG SQL Statements

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

Line: 60

    SELECT inventory_item_id,
           transaction_quantity,
           source_code,
           transaction_action_id,
           transaction_type_id,
           transaction_source_type_id,
           ship_to_location_id,
           organization_id,
	   transaction_id,
	   parent_transaction_id
    FROM mtl_material_transactions
    WHERE transaction_id = p_transaction_id;

Line: 76

    SELECT type_class,
           transaction_source_type_id,
           nvl(location_required_flag,'N') location_required_flag
    FROM mtl_trx_types_view
    WHERE transaction_type_id = pc_transaction_type_id;

Line: 83

SELECT entity_type
FROM  wip_entities we,
      mtl_material_transactions mmt
WHERE mmt.transaction_source_id=we.wip_entity_id
AND   mmt.transaction_id=  p_transaction_id;

Line: 93

    SELECT organization_id
    FROM mtl_material_transactions
    WHERE transaction_id = pc_par_txn_id;

Line: 98

    SELECT transaction_id
    FROM mtl_material_transactions
    WHERE transaction_id = pc_transaction_id
    AND   organization_id = pc_parent_org;

Line: 129

  SELECT master_organization_id
  INTO l_master_org_id
  FROM mtl_parameters
  WHERE organization_id = r_mtl_data.organization_id;

Line: 1892

    l_trx_error_rec.error_stage          := csi_inv_trxs_pkg.g_ib_update;

Line: 1912

    l_trx_error_rec.error_stage          := csi_inv_trxs_pkg.g_ib_update;

Line: 1937

    l_trx_error_rec.error_stage          := csi_inv_trxs_pkg.g_ib_update;